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

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!

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

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

Regards,
Ryan---

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


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

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

Try something like this:

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

--
Biff
Microsoft Excel MVP


"KMA" wrote in message
...
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!

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!

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

Hi,

Create a Pivot table. Drag column C to the row area and column B to the
data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KMA" wrote in message
...
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!

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

I think this is what you want:
http://blogs.techrepublic.com.com/msoffice/?p=416

You may want to consider using a Pivot Table too (or as an alternative):
http://peltiertech.com/Excel/Pivots/pivottables.htm
http://www.babeled.com/2008/07/18/ex...-manipulation/

HTH,
Ryan--


"Ashish Mathur" wrote:

Hi,

Create a Pivot table. Drag column C to the row area and column B to the
data area.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"KMA" wrote in message
...
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!

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

Mike, this worked perfectly, thanks soooo much.

"Mike H" wrote:

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!