Rows to Columns Summary Table

[sbeatty]

Hello all,

I am a bit stumped on a report and am looking for some assistance. The concept involves flipping the axis on the datasource into a summary table, so it appears that I need a SUMIF formula based on the duplicate values, but I'm guessing I'll also need some sort of match formula to indicate to MS Excel which customer I hoping to identify.

Perhaps my sample workbook will be a better description *please see attached*

Thanks all!
Scott

[avk]

With "Sumproduct" function you can do. Refer Attach file.
In this file sum of total with criteria product & number range.
In "B18" formula

Please Login or Register  to view this content.

copy paste across.
Array formula ensure [SHIFT+CTRL+ENTER]

[sbeatty]

Thanks AVK!

I actually figured it out using a slightly different method but thank you. I'm a bit more familiar with SUMIFS and INDEX/MATCH so I did a combo using those methods.

All the best,
Scott