Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
From SUMIF to COUNTIF
Hello,
Can anyone help me please? I need a formula to count non blank cells within a rolling year. (The dates are in the top row, and the days/occassions sick are in the rows below) My initial formula: =SUMIF(($S$1:$IV$1=TODAY()-365)*S2:IV2) adds up all the figures (total days sick) correctly within the rolling 12 months, but I also need to count the non blank cells (occasions) for the same condition. i.e if someone has been off sick for 4 days in one week I want excel to count this as 1 rather than 4. I thought that by changing 'SUMIF' to 'COUNTIF' would work, but it doesn't. Any ideas? Jennie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif & Sumif | Excel Worksheet Functions | |||
SUMIF/COUNTIF | Excel Discussion (Misc queries) | |||
COUNTIF or SUMIF or ?? | Excel Worksheet Functions | |||
Countif and sumif | Excel Discussion (Misc queries) | |||
Countif, Sumif | Excel Worksheet Functions |