Hello Members,
Can anyone help me with the COUNTIFS function for headcount in this file? I have to input the criteria manually as I cannot reference it to column D. The formula should work from cell 233E to 250E. For further clarification, please refer to cells 233F to 250F to understand what I am trying to explain.
Any help will be greatly appreciated.
Regards,
Navin
From Australia, Perth
Acknowledge(1)
Amend(0)
1Can anyone help me with the COUNTIFS function for headcount in this file? I have to input the criteria manually as I cannot reference it to column D. The formula should work from cell 233E to 250E. For further clarification, please refer to cells 233F to 250F to understand what I am trying to explain.
Any help will be greatly appreciated.
Regards,
Navin
From Australia, Perth
Acknowledge(1)Amend(0)
Hello Navin,
I did my best, but it's not working because the department codes mentioned in the sheet are in the format of dates. To solve this issue, you will need to write a macro to obtain the count.
From India, Nizamabad
Acknowledge(0)Amend(0)
I did my best, but it's not working because the department codes mentioned in the sheet are in the format of dates. To solve this issue, you will need to write a macro to obtain the count.
From India, Nizamabad
Acknowledge(0)Amend(0)
Hi,
What I want is, instead of typing criteria in the formula, can't I refer to specific cells so that I don't have to type "dept code" in each cell? In an Excel spreadsheet, there are examples of both situations: in one, I typed the "dept codes" and it worked, and in the other, I have given cell references, but it's not working - the result is zero.
I think this explanation should be all right. Thanks for your efforts.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
What I want is, instead of typing criteria in the formula, can't I refer to specific cells so that I don't have to type "dept code" in each cell? In an Excel spreadsheet, there are examples of both situations: in one, I typed the "dept codes" and it worked, and in the other, I have given cell references, but it's not working - the result is zero.
I think this explanation should be all right. Thanks for your efforts.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
Hi Manikanth, Thanks for trying. In fact this is what one of my excel expert friend told me. But I though to have a try. As there is always a "Sava Ser on Ser". Thanks for ur help.
From Australia, Perth
Acknowledge(0)Amend(0)
From Australia, Perth
Acknowledge(0)Amend(0)
check the summary sheet in workbook and see if it is what you want. Not sure if i got the problem statment correctly.
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Could you please explain it in details that what you want as a result in that column. Hope you will get the solution if you will describe in details
From India, Delhi
Acknowledge(0)Amend(0)
From India, Delhi
Acknowledge(0)Amend(0)
Hi Navin,
It's the same as what you have done in column E. If you want headcount department-wise, first, you need to extract department data from the "default cost account" column using the LEFT formula. I have attached your file with the formula.
Best regards,
Sheikh
From India, New Delhi
Acknowledge(0)Amend(0)
It's the same as what you have done in column E. If you want headcount department-wise, first, you need to extract department data from the "default cost account" column using the LEFT formula. I have attached your file with the formula.
Best regards,
Sheikh
From India, New Delhi
Acknowledge(0)Amend(0)
this is custom function you are using, so this may not work on cell reference. I have used another countif which is giving the same results, hopefully will solve your purpose. Cheers
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
Hi,
You should understand that the Excel functions reduce your calculations and are error-free. The function COUNTIFS will work with large data. I don't think there is a solution for your query.
For more clarity, your sheet has a column "C" which is to be counted department-wise, right? So, you used the COUNTIFS command and got the number of employees in that particular department (i.e., '1-1-11'). If you refer to a specific cell and count, it will not work.
Hope it is clear.
From India
Acknowledge(0)Amend(0)
You should understand that the Excel functions reduce your calculations and are error-free. The function COUNTIFS will work with large data. I don't think there is a solution for your query.
For more clarity, your sheet has a column "C" which is to be counted department-wise, right? So, you used the COUNTIFS command and got the number of employees in that particular department (i.e., '1-1-11'). If you refer to a specific cell and count, it will not work.
Hope it is clear.
From India
Acknowledge(0)Amend(0)
Hi there,
You are a champ. This is exactly what I want, but I was using COUNTIFS instead of COUNTIF. The formula you used, COUNTIF(C:C,"*"&D233&"*"), went over my head. I know the end result is exactly what I want, and I will save this worksheet so I can refer to the function you used in the future. Can you help me understand why "*" is different from "*" which I have used?
Many thanks for your help, buddy.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
You are a champ. This is exactly what I want, but I was using COUNTIFS instead of COUNTIF. The formula you used, COUNTIF(C:C,"*"&D233&"*"), went over my head. I know the end result is exactly what I want, and I will save this worksheet so I can refer to the function you used in the future. Can you help me understand why "*" is different from "*" which I have used?
Many thanks for your help, buddy.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
Hi Friends,
I need one more favor. I thought to post it separately but was sure I would be able to get a solution from one of you. Attached is another workbook in which I need some help.
Sheet "Acrobat to Excel" has tag numbers in column B and amounts in column C. I want to find a formula or a way to display the tag number and the following amount in the same row. For example, 7487981- and $3 in cells D3 and E3.
Currently, I copy column B and C, paste them into a different sheet, sort the tags in sequence, match them with the respective amounts, and then copy and paste them again. This method works fine, but it feels like there is an additional step that I wish to avoid.
I have attached the sheet herewith. Please let me know if you have any questions.
Thank you in advance.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
I need one more favor. I thought to post it separately but was sure I would be able to get a solution from one of you. Attached is another workbook in which I need some help.
Sheet "Acrobat to Excel" has tag numbers in column B and amounts in column C. I want to find a formula or a way to display the tag number and the following amount in the same row. For example, 7487981- and $3 in cells D3 and E3.
Currently, I copy column B and C, paste them into a different sheet, sort the tags in sequence, match them with the respective amounts, and then copy and paste them again. This method works fine, but it feels like there is an additional step that I wish to avoid.
I have attached the sheet herewith. Please let me know if you have any questions.
Thank you in advance.
Regards,
Navin
From Australia, Perth
Acknowledge(0)Amend(0)
Pl chk if this is what u want. It is not working in ur case because, the criteria that u r looking (eg. d233) is not an exact match in column c
From Saudi+Arabia, Riyadh
Acknowledge(0)Amend(0)
From Saudi+Arabia, Riyadh
Acknowledge(0)Amend(0)
hi nickkan., i think i tried some best solution for your excel problem. please check it out and reply me... if it is correct solution.
From India, Coimbatore
Acknowledge(0)Amend(0)
From India, Coimbatore
Acknowledge(0)Amend(0)
Instead of dept you can get no of employee by using cell reference of code only. why you have to creat one more column Dept. other option i am looking in to that once i find i will reply
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hello niccken i found some solution for your problem. please see it.
From India, Coimbatore
Acknowledge(0)Amend(0)
From India, Coimbatore
Acknowledge(0)Amend(0)
When you use a cell reference and apply the * option, it should be accompanied by &, as that's how Excel functions. If you are not using a cell reference, then you can apply the * option without &.
Hope this clarifies your doubt.
Cheers
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
Hope this clarifies your doubt.
Cheers
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
When I opened this file, it shows me binary digits like character. I really can not read this file, so really can not help by the time file cotains proper information. Cheers!
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
From United Kingdom, Hounslow
Acknowledge(0)Amend(0)
Dear, Check the attached file. Hope that your problem has been solved. Any clarification, please revert back. Best Regards, Alam
From Oman, Muscat
Acknowledge(0)Amend(0)
From Oman, Muscat
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Functions Dictionary.xls
23_excel funaction and data analysis tool.pdf