How to add values in one column based on values in another column

  • Thread starter Thread starter KMA
  • Start date Start date
K

KMA

Hello, my spreadsheet has one column (B) with numbers in it and another
column (C) with text values in it (for example, check, AMEX, Visa). For every
instance of the same value in column C I want to sum the corresponding
numbers in column B. In other words, I want to know the total of all invoices
paid with a check, Visa, etc. Any tips or help with creating this formula
would be greatly appreciated. Thanks!
 
Thsi should be pretty easy; definitely doable. Please give a specific
example, with before and after examples.

Regards,
Ryan---
 
Try something like this:

=SUMIF(C1:C10,"check",B1:B10)
=SUMIF(C1:C10,"amex",B1:B10)
=SUMIF(C1:C10,"visa",B1:B10)
 
Back
Top