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

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!
 
R

ryguy7272

Thsi should be pretty easy; definitely doable. Please give a specific
example, with before and after examples.

Regards,
Ryan---
 
T

T. Valko

Try something like this:

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

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

Sum Values from different column 1
Sum of values in column A based on 0/1 of column B 2
Copy Data from One Spreadsheet to Another ?????? 5
Get sum of values in a cell based on unique values in another cell 3
Sumif or Sumproduct? 2
Reposition Cells in a Column based on another 2
Unhide column difficulty 3
Macro to change referenced column to the next one 1

Top