nickkan
1

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.
Regards,
Navin

From Australia, Perth
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (33.5 KB, 981 views)

mani.ragi
10

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.

From India, Nizamabad
nickkan
1

Hi,
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.
Regards,
Navin

From Australia, Perth
nickkan
1

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
sanjaykaul
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
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (41.5 KB, 226 views)

Aakil
1

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
Sheikh Jauwad Ali
1

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

From India, New Delhi
Attached Files (Download Requires Membership)
File Type: xls EXCEL HELP IN COUNTIFS FUNCTION.XLS (51.0 KB, 146 views)

carora
1

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
Attached Files (Download Requires Membership)
File Type: xls EXCEL%20HELP%20IN%20COUNTIFS%20FUNCTION(1).XLS (42.0 KB, 162 views)

manohargoudc
HI
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

From India
nickkan
1

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.
Regards,
Navin

From Australia, Perth
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.