Aggregating data without a pivot?

[adr150]

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!

[arthurbr]

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)

[adr150]

awesome, thanks a lot!!

[arthurbr]

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

[adr150]

how do i show it as solved?

[arthurbr]

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

[adr150]

thanks...........

[arthurbr]

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