Hi there,

Check out some of these resources ...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
http://www.mrexcel.com/wwwboard/messages/8961.html
http://www.mcgimpsey.com/excel/variablerate.html

You may be able to use some kind of permutation from this ...

=SUMPRODUCT(C1:C100,--(B1:B100="JP Planes"),--(A1:A100="JP Planes"))

HTH

--
Regards,
Zack Barresse, aka firefytr


"BannerBrat" wrote
in message ...

I'm hoping someone can help me here.
I'm tring to sum column C if it equals B and equals A.
For example:
DF GF HG JK JP
Planes
Trains
Automobiles
------------------------------------------------------
A B C
Name Trans. Num
JP Planes 1
JP Trains 3
GF Automobiles 4
JP Planes 5
GF Trains 6
JK Automobiles 7
DF Planes 8
HG Trains 9
HG Automobiles 4
JP Planes 3
GF Trains 2
JK Automobiles 1


--
BannerBrat
------------------------------------------------------------------------
BannerBrat's Profile:
http://www.excelforum.com/member.php...fo&userid=5485
View this thread: http://www.excelforum.com/showthread...hreadid=395118