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 |
#2
|
|||
|
|||
adding amounts according to labels
Your formula looks fine to me.
Are you perhaps importing your data into Column D, so that there might be a possibility that there are "invisible" characters present, which wouldn't be recognized by the formula. Manually enter "rent" (no quotes) into a cell in Column D and see if you get a return. Also, there's the possibility that the values in Column E are not true numbers. Make a manual entry there also for a test. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Wayne Cameron" wrote in message ... 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 |
Reply |
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 |