I love quick ways.
Thanks
This works great until I clear my data sheet, then however the d27 etc totals become #N/A due to data missing in the previous calculations and this activates the msgbox warning. Is there a way I can either only run the code when there is data in a certain cell or change #N/A to 0 IF(d27=#N/A,1,0) dont work.
Thanks
Nobby