Sum and If
 

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

Sum and If
 

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

Regards
FSt1

"Shirl" wrote:

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

Sum and If
 

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

Regards,
Howard

"Shirl" wrote in message
...
I am wanting to add numbers in Column B,d,f etc only if it equals the text
in
Column A,c,e etc
--
Shirl, NZ

Sum and If
 

Try this...

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

Note how the ranges are offset.

--
Biff
Microsoft Excel MVP


"Shirl" wrote in message
...
I am wanting to add numbers in Column B,d,f etc only if it equals the text
in
Column A,c,e etc
--
Shirl, NZ

Sum and If
 

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

Howard

"Shirl" wrote in message
...
I am wanting to add numbers in Column B,d,f etc only if it equals the text
in
Column A,c,e etc
--
Shirl, NZ