| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
summing values from adjacent column with refrence from adjacent column
sup pros i have this info A1: MSFT A2: CAT A3: MSFT A4: IBM A5: MSFT A6: MSFT A7: CSCO A8: MSFT A9: MSFT & B1: 26.20 B2: 76.00 B3: 26.21 B4: 81.45 B5: 26.20 B6: 26.19 B7: 18.20 B8: 26.20 B9: 26.23 & C1: 23,670 C2: 76.00 C3: 20,000 C4: 81.45 C5: 25,998 C6: 34,005 C7: 18.20 C8: 35,000 C9: 17,050 I want to sum up the values in column C if only at this condition , the adjacent column (B) is at 26.20 & column (A) is MSFT the result would be C1 , C5 , & C8 = 23,670+25,998+35,000 = 84,668 how do i do that ? -- Pivotrend ------------------------------------------------------------------------ Pivotrend's Profile: http://www.excelforum.com/member.php...fo&userid=4062 View this thread: http://www.excelforum.com/showthread...hreadid=518953 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum up values from adjacent column | Excel Discussion (Misc queries) | |||
| linking values of column A to values of column B | Excel Discussion (Misc queries) | |||
| How to get the values using a condition refering to the other column | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| match and count words | Excel Worksheet Functions | |||
Threaded Mode
