View Single Post
 
Old 12-28-2016, 02:07 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

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.
Reply With Quote