| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum up values from adjacent column
sup pros i have in cells A1:2200 A2:2200 A3:2190 A4:2180 A5:2200 A6:2170 A7:2200 A8:2200 A9:2160 & in cells B1:1,000 B2:3,000 B3:2,000 B4:7,000 B5:2,000 B6:1,000 B7:2,500 B8:3,000 B9:1,000 i want to sum up the values in columns B if the adjacent number in column A = 2200 which would Be the values in B1 B2 B5 B7 B8 = 11,500 because there adjacent Cells in coulumn A reads 2200 which are A1 A2 A5 A7 A8 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=514779 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup values in one column to return another | Excel Worksheet Functions | |||
| To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Column Chart with 2 values in each column | Charts and Charting in Excel | |||
| Can you average data in 1 column based on a range of values in another? | Excel Worksheet Functions | |||
Threaded Mode
