[Tammy]

Hi there -
I'm sure this is simple, but I can't figure it out.'

I'm adding $$ on a spreadsheet and want to total out by payment types

For example, Column B has my types of money, google, paypal, amazon, etc.

I want to add up the total for column C where column b = paypal, then a
total for column c where b = google, etc....

[T. Valko]

Try this:

=SUMIF(B:B,"paypal",C:C)

Better to use a cell to hold the criteria:

A1 = paypal

=SUMIF(B:B,A1,C:C)

--
Biff
Microsoft Excel MVP


"Tammy" wrote in message
...
Hi there -
I'm sure this is simple, but I can't figure it out.'

I'm adding $$ on a spreadsheet and want to total out by payment types

For example, Column B has my types of money, google, paypal, amazon, etc.

I want to add up the total for column C where column b = paypal, then a
total for column c where b = google, etc....

[FSt1]

hi
=sumif(B1:B100,"Google",C1:C100)
or
=sumif(B:B,"Paypale",C:C)

regards
FSt1

"Tammy" wrote:

Hi there -
I'm sure this is simple, but I can't figure it out.'

I'm adding $$ on a spreadsheet and want to total out by payment types

For example, Column B has my types of money, google, paypal, amazon, etc.

I want to add up the total for column C where column b = paypal, then a
total for column c where b = google, etc....

[Tammy]

Hi - i tried them both, but i'm getting a result of "false" ..
any thoughts?

"FSt1" wrote:

hi
=sumif(B1:B100,"Google",C1:C100)
or
=sumif(B:B,"Paypale",C:C)

regards
FSt1

"Tammy" wrote:

Hi there -
I'm sure this is simple, but I can't figure it out.'

I'm adding $$ on a spreadsheet and want to total out by payment types

For example, Column B has my types of money, google, paypal, amazon, etc.

I want to add up the total for column C where column b = paypal, then a
total for column c where b = google, etc....

[FSt1]

hi
post a sample of your data.

Regards
FSt1

"Tammy" wrote:

Hi - i tried them both, but i'm getting a result of "false" ..
any thoughts?

"FSt1" wrote:

hi
=sumif(B1:B100,"Google",C1:C100)
or
=sumif(B:B,"Paypale",C:C)

regards
FSt1

"Tammy" wrote:

Hi there -
I'm sure this is simple, but I can't figure it out.'

I'm adding $$ on a spreadsheet and want to total out by payment types

For example, Column B has my types of money, google, paypal, amazon, etc.

I want to add up the total for column C where column b = paypal, then a
total for column c where b = google, etc....