Network Security, Network Management, Project
Hr Professional
Question Me & Rate...!
+5 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hello Members,
Can anyone help me with this file in countifs function for headcount. I have to type in the criteria, I can't refer it to column D.Formula worked as in 233E to 250E. For your reference please see 233F to 250F to understand what I am try to explain.
Help will be appreciated.

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (33.5 KB, 951 views)

Hello Navin,
I did my best but it's notworking because,
the dept codes which are metioned in the sheet are in the format of dates so for this the solution is u have to write a macro to get the count.

What I want is instead of typing criteria in the formula can't I refer it to specific cells. so that I don't have to type "dept code" in each cell.
In excel spreadsheet there is example of both the situations in one I typed the "dept codes" and it worked and in other I have given cell reference and its not working "result is zero".
I think this explaination should be allright.
Thansks for ur efforts.

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.
check the summary sheet in workbook and see if it is what you want. Not sure if i got the problem statment correctly.

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (41.5 KB, 223 views)

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
Hi naveen,
It's same as you have done in column E,
If you want headcount dept. wise, first u need extract dept. data from "default cost account" column by using of left formula. attached here your file with formula...... Sheikh

Attached Files
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (51.0 KB, 142 views)

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

Attached Files
File Type: xls EXCEL%20HELP%20IN%20COUNTIFS%20FUNCTION(1).XLS (42.0 KB, 157 views)

You should understand that the excel functions reduce your calculation and are error free. the function countifs will work with large data.
I dont think there is a solution for your query.
For more clarity.....your sheet has a column "c" which is to be counted dept wise....right...so you used countifs command and got the number of employees in that particular dept (i.e.'1-1-11'). If you refer to a specific cell and count...it will not work.
Hope it is clear

Hi there,
You are a CHAMP. This is what I exactly want. but I was using Countifs instead of coutif.
But still the formula use used COUNTIF(C:C,"*"&D233&"*"), went over my head.
I know end result is exactly what I want and I will save this worksheey, so I can refer the function u used in future.
But can you help me to understand why "*" is different to "* which I have used.
Many thanks for your help buddy.

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™