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)
=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)
This is exactly what I needed. I'm using Office 365, so the first formula works perfectly. Thank you so much!!