Good day

i have a work book that make use of if and sumif to calculate and show data to 9 different blocks of data...

would it be posible to make a if/sumif or a macro to make it easier and shorter sum than currently? at the moment the blocks only use data for the first 5 items. and i expanded the items. do not feel like editing every sumif/if calculation


http://www.home-bound.co.za/saladlabel.xlsm for the file

the 9 block are located on 'new label' and the data file on 'data sheet'

regards

phillip