You're very welcome and thanks for the feedback.
Look at the offset ranges.
The criteria range starts in column A with the sum range beginning in column B.
=SUMIF(range,criteria,sum_range)
As long as the blank columns (C and F) remained spaced out in the same manner, you can use this sumif for more columns keeping the same pattern.
|