for Toppers and Barb
 

thanks for your reply, u r really super, I guess wasnt specific with what
I wanted to do, if I have in column B2 23, B3 34, B5 20, B7 16, and in
column C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c, A7 b.
Total sum in column B for all rows that are a only, total in column B for all
rows that are b only total sum in column C for all rows that are c only. Can
it be done in excel?
Thank u again

for Toppers and Barb
 

I'm not a Toppers or Barb. I'm a "Teethless mama" I can help

=SUMIF(A2:A7,"b",B2:B7)

=SUMIF(A2:A7,"c",C2:C7)


"yodochi" wrote:

thanks for your reply, u r really super, I guess wasnt specific with what
I wanted to do, if I have in column B2 23, B3 34, B5 20, B7 16, and in
column C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c, A7 b.
Total sum in column B for all rows that are a only, total in column B for all
rows that are b only total sum in column C for all rows that are c only. Can
it be done in excel?
Thank u again

for Toppers and Barb
 

thanks!

"Teethless mama" wrote:

I'm not a Toppers or Barb. I'm a "Teethless mama" I can help

=SUMIF(A2:A7,"b",B2:B7)

=SUMIF(A2:A7,"c",C2:C7)


"yodochi" wrote:

thanks for your reply, u r really super, I guess wasnt specific with what
I wanted to do, if I have in column B2 23, B3 34, B5 20, B7 16, and in
column C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c, A7 b.
Total sum in column B for all rows that are a only, total in column B for all
rows that are b only total sum in column C for all rows that are c only. Can
it be done in excel?
Thank u again

for Toppers and Barb
 

BTW, shouldn't it be toothless?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Teethless mama" wrote in message
...
I'm not a Toppers or Barb. I'm a "Teethless mama" I can help

=SUMIF(A2:A7,"b",B2:B7)

=SUMIF(A2:A7,"c",C2:C7)


"yodochi" wrote:

thanks for your reply, u r really super, I guess wasn't specific with
what
I wanted to do, if I have in column B2 23, B3 34, B5 20, B7 16, and in
column C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c,
A7 b.
Total sum in column B for all rows that are a only, total in column B for
all
rows that are b only total sum in column C for all rows that are c only.
Can
it be done in excel?
Thank u again