Thread: Aggregating data without a pivot?

I am trying to create a formula that will aggregate different levels of data without using a pivot table.

For example, i would like for my formula to return the summarized sales of Region 1. I don't want to use the sum formula because I might want to summarize by common division, such as Telecom. To do this I would at least need an input cell to define the level of detail

Region Division Sales
Region 1 Telecom 4291
Region 1 Devices 1032
Region 2 Telecom 2054
Region 2 Devices 3952


ive tried using different combinations of IF, VLOOKUP, and SUM statements, but nothing is working yet.

Any ideas would be greatly appreciated!

try the sumproduct function like =sumproduct((a1:a4="region 1")*(b1:b4="telecom")*c1:c4)
Adapt the ranges to your need but they all must have the same length ( ranges like b:b are not accepted)

Glad to help. Don't forget to indicate your thread as solved !

Go to Quick Reply select Go advanced - Scroll up to your title and changethe prefix - Thx for asking

adr150 thx , that is not quite waht I meant.. I'll do it for you - It should be changed in the original post ;-)