Forum Discussion
Solved
Sum of Range based on numbers in a different row
Hi, I would appreciate any help I can receive on this spreadsheet, which is being used for tracking employee absence. I am trying to sum the total of a range.(the sum of the hours taken in the month...
=SUM((B5:AF5="X")*(B$4:AF$4),B5:AF5)or for older versions of Excel:
=SUMPRODUCT((B5:AF5="X")*(B$4:AF$4),B5:AF5)
Sorry, you are correct.
I thought I posted the correct formula.
This is the correct one:
=SUM(SUMPRODUCT((B5:AF5="X")*(B$4:AF$4)),B5:AF5)
