Flora Edwards
asked on
Alternative to SUMIF
Hello
please see attached file. i need two help to simplify this formula in Column E.
i need help with using any alternative formula or existing one, that eliminates the helper column of "D".
it does not matter if the formula becomes an array formula.
ee.xlsx
please see attached file. i need two help to simplify this formula in Column E.
i need help with using any alternative formula or existing one, that eliminates the helper column of "D".
it does not matter if the formula becomes an array formula.
ee.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Rory,
thanks A million.
it was a typo on the formula DV is D. so your solution worked.
thanks A million.
it was a typo on the formula DV is D. so your solution worked.
ASKER
Thank you James. your formula worked too.
Open in new window
*btw, I think this also fixes the erroneous reference to column DV in your original formula.