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.