A user I am trying to help has a spread sheet that has several columns
and he would like to sum one of the columns IF 2 other columns equal
certain data
If Column A = place ? AND Column C = ? then add Column D for a total

ColA ColB ColC ColD
Location Text Rating Points

place 1 blah A 5
place 1 blah B 4
place 2 blah B 4
place 2 blah C 3
place 1 blah C 3

place 1 total A - formula to total all Place 1s and As (5)
place 2 total B - formula to total all Place 1s and Bs (8)
etc
etc

I'm sure I need to use SUMIF but I can't figure out how to involve
multiple criteria to the formula. Any help would be greatly
appreciated.


--
macquarl
------------------------------------------------------------------------
macquarl's Profile: http://www.excelforum.com/member.php...o&userid=26388
View this thread: http://www.excelforum.com/showthread...hreadid=498115