View Single Post
  #1   Report Post  
BannerBrat
 
Posts: n/a
Default Sum with two conditions


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