| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum up values from adjacent column
Enter 2200 in C1 then in D1 enter this formula:
=SUMIF(A1:A9,C1,B1:B9) This enables you to change the criteria in C1 without having to change the formula - maybe relevant to your other post. Hope this helps. Pete |
| 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
