| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT formula to include additonal range
How do I get the formula below to also include the value "in progress",
please see in the formula how I have written "resolved" and "closed". What must I add to the formula in order to get it to also check the "in progress value"? =SUMPRODUCT(('Jira Reference'!$E5:$E1000="resolved")*('Jira Reference'!$J5:$J1000<=C5)*('Jira Reference'!$L5:$L1000))/2/3600+SUMPRODUCT(('Jira Reference'!$E5:$E1000="closed")*('Jira Reference'!$J5:$J1000<=C5)*('Jira Reference'!$L5:$L1000))/3600 -- Brile |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I include only visible cells in a range? | Excel Worksheet Functions | |||
| include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
| IF with additonal Functions | Excel Worksheet Functions | |||
| Changing a range of an array in a SUMPRODUCT formula gives a #N/A error | Excel Discussion (Misc queries) | |||
| sum a range of cells that include an error | Excel Discussion (Misc queries) | |||
Threaded Mode
