Hi, This is just an example or sample of what I would like to do on a much larger spreadsheet and the solution we find should apply easily.

On the attached sheet I want to fill in the "Totals" area that has the ??? with the sum of all data with the same label that is scattered throughout the sheet. The value for each label is consistently one cell to the right of the label. Is it possible to do this with ONE formula in the totals area?

I was able to pull it off with hidden SUMIFs for each column and label and then SUM all of the SUMIFs for each label in the totals area, but I thought there might be a more elegant solution with just one formula for each total.

Ideas?

Thanks.

P

Attached Files

Example.xlsx (10.4 KB, 9 views)

Try in K13 and copied down...

=SUMIF(A:G,J13,B:H)

Yes! thsi worked! Not 100% sure why it worked but it does. thanks.

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.