| Home |
| Search |
| Today's Posts |
|
#5
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! |
| 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 | |||
Threaded Mode
