Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT formula
Hello,
I've got a formula which works perfectly to sum the number of days someone has been off sick in a rolling year, however I also need to count the number of occassions people have been off. Can anyone help me develop my existing formula or is there a totally diferent way to do it? I'm stuck. :( This is my current formula: =SUMPRODUCT(($S$1:$IV$1=TODAY()-365)*S2:IV2) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
sumproduct formula | Excel Discussion (Misc queries) | |||
OR in a SUMPRODUCT formula | Excel Worksheet Functions | |||
SumProduct Formula Help | Excel Worksheet Functions | |||
sumproduct formula | Excel Worksheet Functions |