=SUM(IF(H17:H26=0,0,IF((COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(11,COLUMNS($H27:H27)-1),,MIN(12,COLUMNS($H27:H27))),">0")>=6)+(COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(3,COLUMNS($H27:H27)-1),,MIN(4,COLUMNS($H27:H27))),">0")=4),2,IF((COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(11,COLUMNS($H27:H27)-1),,MIN(12,COLUMNS($H27:H27))),">0")>=4)+(COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(2,COLUMNS($H27:H27)-1),,MIN(3,COLUMNS($H27:H27))),">0")=3),1.75,IF((COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(11,COLUMNS($H27:H27)-1),,MIN(12,COLUMNS($H27:H27))),">0")=3)+(COUNTIF(OFFSET(H17,ROW(H17:H26)-ROW(H17),-MIN(1,COLUMNS($H27:H27)-1),,MIN(2,COLUMNS($H27:H27))),">0")=2),1.5,1))))*(H17:H26))
Try this and copy towards right, hope some one will come up with simple formula
Bookmarks