I don't know sumproducts, I haven't had the time to get my head around it and the spreadsheet is live and people will continue to us ethe spreadsheet so cell range will have to be whole columns.