Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
trying to write a formula that adds values in one column if another column
contains like values (cusip) can't do sumif because the value changes every 2 - 10 cells or so and there are 1400 lines in spreadsheet and about 300 cusips I want it sum by cusip. I know there's a simple way but I've exhausted my search. example cusip amt sum by cusip 912810FE3 300 912810FE3 500 800 912803BL6 100 912803BL6 200 912803BL6 300 600 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
vlookup with similar lookup values | Excel Discussion (Misc queries) | |||
Copying cells with similar column values | New Users to Excel | |||
How to chart a single column of values similar to a GROUP BY | Charts and Charting in Excel | |||
Counting cells, similar values | Excel Worksheet Functions | |||
cusip (number and text) in same cell- How do use in excel? | Excel Worksheet Functions |