Countif over a range of cells for various codes.
 

Hello,

I am trying to get a single referance cell for how many holidays I have on a
day in a holiday sheet. I have 22 different employees all with their own area
on the same worksheet, and I have a master section where I am trying to
insert a countif function with arguments, but at present am having no joy.
I was trying
"=IF(H,1,0)(SUM(E8,E13,E18,E23,E28,E33,E38,E43,E48 ,E53,E58,E63,E68,E73,E78,E83,E88,E93,E98,E103,E108 ,E113))"
to see if I could get a cell to work out how many holidays I have in a day,
but would also want to expand this to use about 6 or 7 other referances as
well. With one of the referances this would be for a 1/2 day, so the value to
be returned from that would have to be "0.5".
Is this possible? If so, any advice would be great!

Cheers.

Countif over a range of cells for various codes.
 

Hi AJ,

It is unclear to me what (H,1,0) represents. What is the IF you are using to
determine if something should be counted?

"AJ" wrote:

Hello,

I am trying to get a single referance cell for how many holidays I have on a
day in a holiday sheet. I have 22 different employees all with their own area
on the same worksheet, and I have a master section where I am trying to
insert a countif function with arguments, but at present am having no joy.
I was trying
"=IF(H,1,0)(SUM(E8,E13,E18,E23,E28,E33,E38,E43,E48 ,E53,E58,E63,E68,E73,E78,E83,E88,E93,E98,E103,E108 ,E113))"
to see if I could get a cell to work out how many holidays I have in a day,
but would also want to expand this to use about 6 or 7 other referances as
well. With one of the referances this would be for a 1/2 day, so the value to
be returned from that would have to be "0.5".
Is this possible? If so, any advice would be great!

Cheers.