Hi,
This formula works if there are no 0's in the S12:S206 range.
=(SUMPRODUCT((MONTH('F02-Silage-Milkers'!$G$12:$G$206)=$M12)*(YEAR('F02-Silage-Milkers'!$G$12:$G$206)=$J12)*('F02-Silage-Milkers'!$S$12:$S$206))/1000)
However if the formulas in S12:S206 return a 0 value then the above formula returns a "#VALUE!" error.
Can someone please provide a work around?
Thanks
This formula works if there are no 0's in the S12:S206 range.
=(SUMPRODUCT((MONTH('F02-Silage-Milkers'!$G$12:$G$206)=$M12)*(YEAR('F02-Silage-Milkers'!$G$12:$G$206)=$J12)*('F02-Silage-Milkers'!$S$12:$S$206))/1000)
However if the formulas in S12:S206 return a 0 value then the above formula returns a "#VALUE!" error.
Can someone please provide a work around?
Thanks