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