Originally Posted by
spellbee2
=SUM(B3:B14)
=AVERAGEIF(B3:B14,"<>0")*12
=SUM(B3:B14)+COUNTIF(B3:B14,"")*(AVERAGEIF(B3:B14, "<>0")*0.5)
=SUM(B3:B14)+(COUNTIF(B3:B4,"")*(AVERAGEIF(B3:B4," <>0")*0.5))+(COUNTIF(B5:B9,"")*(AVERAGEIF(B5:B9, "< >0")*0.5))+(COUNTIF(B10:B14,"")*(AVERAGEIF(B10:B 14 ,"<>0")*0.5))
=SUM(B3:B14)+(COUNTIF(B3:B4,"")*(SUM(B$3:B$4,B$18: B$19,B$32:B$33)/COUNT(B$3:B$4,B$18:B$19,B$32:B$33))*0.5)+(COUNTIF( B5:B9,"")*(SUM(B$5:B$9,B$20:B$23,B$34:B$38)/COUNT(B$5:B$9,B$20:B$23,B$34:B$38))*0.5)+(COUNTIF( B10:B14,"")*(SUM(B$10:B$14,B$24:B$28,B$39:B$43)/COUNT(B$10:B$14,B$24:B$28,B$39:B$43))*0.5)