| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Values in 1 Column based on Date Range in another Column | Excel Worksheet Functions | |||
| Based on data in previous column - sum of values in next column | Excel Worksheet Functions | |||
| Adding multiple values in one column based on multiple values of the same value (text) in another column | Excel Discussion (Misc queries) | |||
| Adding numerical values based on multiple values in another column | Excel Worksheet Functions | |||
| Count entries in one column based on values in another column | Excel Worksheet Functions | |||
Linear Mode
