S
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
Column A,c,e etc
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
FSt1
hi
try this..
=SUMIF(B2:B8,"text",A2:A8)
or
sumif(range with criteria, criteria, range to sum)
Regards
FSt1
try this..
=SUMIF(B2:B8,"text",A2:A8)
or
sumif(range with criteria, criteria, range to sum)
Regards
FSt1
L
L. Howard Kittle
I might be overlooking the obvious, but how can NUMBERS in a column equal
TEXT in another column?
Regards,
Howard
TEXT in another column?
Regards,
Howard
T
T. Valko
Try this...
=SUMIF(A1:E5,"x",B1:F5)
Note how the ranges are offset.
=SUMIF(A1:E5,"x",B1:F5)
Note how the ranges are offset.
L
L. Howard Kittle
Okay, I'm still learning...<bg>
Howard
Howard