Excel help on countifs

nickkan · #1 21-10-2009, 05:04 AM

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

Joshuaalvina · #2 21-10-2009, 11:28 AM

yes i am working with your file but u should have to explain clearly...............

Regards,
J/A

mani.ragi · #3 21-10-2009, 11:58 AM

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.

nickkan · #4 22-10-2009, 06:03 AM

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

Quote:

Originally Posted by Joshuaalvina

yes i am working with your file but u should have to explain clearly...............

Regards,
J/A

nickkan · #5 22-10-2009, 06:07 AM

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.

Quote:

Originally Posted by mani.ragi

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.

sanjaykaul · #6 22-10-2009, 03:08 PM

check the summary sheet in workbook and see if it is what you want. Not sure if i got the problem statment correctly.

dev7700 · #7 22-10-2009, 04:00 PM

No difference I've found

Aakil · #8 22-10-2009, 04:54 PM

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

Sheikh Jauwad Ali · #9 22-10-2009, 06:46 PM

Quote:

Originally Posted by nickkan

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

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

carora · #10 22-10-2009, 06:47 PM

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

Quote:

Originally Posted by nickkan

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