Formula to only calculate totals when text entered in other cells

[excelteam777]

A1:A10 = random amounts entered
B1:B10 = text entry
C1 = formula
Right now I have C1 totaling A1:A10 and populating the sum by using =SUM(A1:A10)
I want to add into the formula to only sum the amounts in A1:A10 if “R” is entered into B1:B10

See Attached Spreadsheet

[XOR LX]

Hi,

=SUMIF(B:B,"R",A:A)

Regards

[excelteam777]

im sorry, I meant to reverse that. I wanted it not to SUM all totals except the ones where as "R" was entered into B:B

[martindwilson]

=sumif(b:b,"<>r",a:a)

[XOR LX]

"I wanted it not to SUM all totals except the ones where as "R" was entered into B:B"

So this "not" shouldn't be in that sentence? Otherwise it's getting extremely confusing!

Either way:

=SUMIF(B:B,"<>R",A:A)

Regards

[Tony Valko]

Based on the sample file tell us which cells should be summed.

[excelteam777]

thx I appreciate it