sum and if statements

J

jimk

I need to add A column of numbers based on the criteria in a seperate column

example
col b col c
yds passing qb number
5 10
8 5
7 10
i want to add the yds passing by qb 10 and yds passing of qb 5 in a formula
that will record them in a seperate spot in a worksheet
 
H

HiArt

Hi Jim,

try...

=SumIf(C2:C4,"=10",B2:B4)
=SumIf(C2:C4,"=5",B2:B4)

Obviously adjusting the C2:c4 and B2:B4 ranges to suit!

HTH

Art
 
B

Bob Phillips

=SumIf(C2:C4,10,B2:B4)
=SumIf(C2:C4,5,B2:B4)

is more appropriateb if they are numbers, or maybe a pivot table.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top