View Single Post
  #1   Report Post  
Wayne Cameron
 
Posts: n/a
Default 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