adding 2 columns where

  • Thread starter Thread starter Tammy
  • Start date Start date
T

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....
 
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)
 
hi
=sumif(B1:B100,"Google",C1:C100)
or
=sumif(B:B,"Paypale",C:C)

regards
FSt1
 
Hi - i tried them both, but i'm getting a result of "false" ..
any thoughts?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

adding 2 columns where 1
Counting days and text in cells 3
Sum Column C for duplicate account number in Column A 8
Having Blank Cells, etc. ? 1
adding columns with decimals out to far 3
sum product sales figures from another column 4
simple addition 4
SUMIF with NAME RANGE 1

Back
Top