| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Cannot sum values based on condition
Hi,
I have four columns of data as follows: A B C D Plan1 20 Plan1 32 Plan4 15 Plan2 13 Plan2 13 Plan3 35 Plan3 17 Plan4 40 Plan1 12 Plan3 18 Plan4 25 I want to sum the values in column B and store it in column D based on the condition that any records in column A match those in column C. Can anyone provide me with a formula to go in column D to solve this? |
|
#2
|
|||
|
|||
|
Hi!
=SUMIF(A$1:A$25,C1,B$1:B$25) Copy down as needed. Biff -----Original Message----- Hi, I have four columns of data as follows: A B C D Plan1 20 Plan1 32 Plan4 15 Plan2 13 Plan2 13 Plan3 35 Plan3 17 Plan4 40 Plan1 12 Plan3 18 Plan4 25 I want to sum the values in column B and store it in column D based on the condition that any records in column A match those in column C. Can anyone provide me with a formula to go in column D to solve this? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| project values based on other values | Excel Discussion (Misc queries) | |||
| make a cell empty based on condition | Charts and Charting in Excel | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
| If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions | |||
| Modify Row & Cell Contents based upon Cells Values | Excel Worksheet Functions | |||
Linear Mode
