I ended up just using a pivot table which seems to work the best and is much
faster.

"JT" wrote:

That still didn't work, thanks for trying though.
Could it be a problem because I am still using office 2003?
Does anyone else have any additional ideas?

"Max" wrote:

Try it like this:
=SUMPRODUCT(($A$2:$A$1500=TEXT(F2,"000"))*($B$2:$B $1500=G2)*$C$2:$C$1500)

See sample:
http://www.freefilehosting.net/download/3b8dj
Sumproduct_1a.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JT" wrote in message
...
I have about 35 BU which are all listed in a column multiple times, as are
the cost/revenue types. I then want to add the total budget for a
specific
bu and c/r type. Here is a very simplified mockup of my spreadsheet.
Ideally I would like to find a total budget for bu 250 and c/r 51, etc.

BU C/R Type Budget Actual
250 51 10 5
035 51 20 25
150 51 10 10
035 52 15 15
250 52 15 10
250 53 30 35
250 51 10 5
035 52 20 20
150 51 10 10