| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
adding amounts according to labels
I have labels in col D (multiple lines but only 7 different labels). I wish
to add the cells in col E into 7 seperate totals (according to label). This is the formula I came up with but it is giving me an incorrect total of 0: =SUMIF(D7:D36,"rent",E7:E36). I would appreciate it if someone could give me some guidance to correct my mistake. Thanks -- D. W. Cameron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add data labels without displaying data points? | Charts and Charting in Excel | |||
| Adding amounts based on a conditional date | Excel Discussion (Misc queries) | |||
| Pivot Table - 'Merge Labels' option and formatting | Excel Worksheet Functions | |||
| Alignment of Multiple-Level Category Labels Not Possible? | Charts and Charting in Excel | |||
| Adding x axis labels | Charts and Charting in Excel | |||
Threaded Mode
