=IF(SUMPRODUCT(($A$5:$A$94=$H5)*($C$5:$C$94<=I$4)*($D$5:$D$94>=I$4)*($E$5:$E$94))=0,"",SUMPRODUCT(($A$5:$A$94=$H5)*($C$5:$C$94<=I$4)*($D$5:$D$94>=I$4)*($E$5:$E$94)))
ExpertEx-1.xls
{Side note: using commas inside of SUMPRODUCT function - rather than multiplication - operates faster}
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Function for selecting rows from data set and combining certain rows based on criteria | 16 | 34 | |
Left trim cells in column A Excel vba | 2 | 31 | |
Excel - conditional formatting on several columns | 9 | 33 | |
Excel - remove duplicates | 1 | 13 |
Join the community of 500,000 technology professionals and ask your questions.