View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default adding 2 columns where

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....