Try Bob Phillips' excellent treatment on SUMPRODUCT at his:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

It handles "Multiple Condition Tests" which seems to what you're trying to
do here
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PhilScratchingmyhead" wrote:
On my spreadsheet I have info from more than one column filtered that I want
to add together onto another worksheet e.g if something in column 'A' = what
I want - then I want it to check if something in column 'B'= something else I
want...then if both criteria are met I want it to add data from column 'C'
onto another sheet. I have used sumif function but it only lets me check one
column and it's criteria but doesn't let me check the second column and it's
criteria before adding.

Any help would be appreciated as everyone here is stck in the dark ages and
were like Excel....huh????

Ta
P.