Excel 2007 has a formula "sumifs" - what do I use in Excel 2003

[LK Wright]

Excel 2007 has a formula "sumifs". What do I use in Excel 2003 to accomplish
the same results?
I have a spreadsheet that I want to search (2) columns for specific items
and then take a dollar value from a third column and sum the values
associated with the specific rows.

ie. column 1 ="schools" column 2 = "lost" column 3 = $1.00

Thanks

 

[Peo Sjoblom]

=SUMPRODUCT(--(A2:A500="schools"),--(B2:B500="lost"),C2:C500)

note that you can't use the whole column in pre 2007



--


Regards,


Peo Sjoblom

 

[Don Guillett]

try.
=sumproduct((a2:a22="schools")*(b2:b22="lost")*c2:c22)
or
=sumproduct((a2:a22="schools")*(b2:b22="lost")*(c2:c22=1.00)*d2:d22)
should also work in 2007 whereas the newer one won't in 2003. Can't use
entire column.