Sum and If

[Shirl]

I am wanting to add numbers in Column B,d,f etc only if it equals the text in
Column A,c,e etc

 

[FSt1]

hi
try this..
=SUMIF(B2:B8,"text",A2:A8)
or
sumif(range with criteria, criteria, range to sum)

Regards
FSt1

 

[L. Howard Kittle]

I might be overlooking the obvious, but how can NUMBERS in a column equal
TEXT in another column?

Regards,
Howard

 

[T. Valko]

Try this...

=SUMIF(A1:E5,"x",B1:F5)

Note how the ranges are offset.

 

[L. Howard Kittle]

Okay, I'm still learning...<bg>

Howard