Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif skips cells in range | Excel Discussion (Misc queries) | |||
COUNTIF in a range (and parts of cells) | Excel Worksheet Functions | |||
How do I count alpha codes in a range of cells in a row? | Excel Discussion (Misc queries) | |||
using countif in isolated cells not a range | Excel Worksheet Functions | |||
Countif for specific cells rather than a range ???? | Excel Worksheet Functions |