Thread: How to add values in one column based on values in another column
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to add values in one column based on values in another column
Try this

=SUMIF(C1:C1000,"Amex",B1:B1000)

Mike

"KMA" wrote:

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!
Reply With QuoteReply With Quote