Countif over a range of cells for various codes.

A

AJ

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.
 
S

Squeaky

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top