Hi folks,
I'm looking for a formula that will sum cells in a row that contain a number >0. Some cells in the row will contain 0 and must be ignored. That's the easy but:
The row in question in the attached workbook is Gross Pay.
Thank you in advance,
Batonman
I'm looking for a formula that will sum cells in a row that contain a number >0. Some cells in the row will contain 0 and must be ignored. That's the easy but:
(1) I need the formula to stop once its identified and summed 15 cells that are >0 and
(2) I need it to count back so that the data is from the most recent weeks 15 weeks.
The row in question in the attached workbook is Gross Pay.
Thank you in advance,
Batonman