I have this formula that works perfect 99% time with drop down combo but have occasions when some depts showing a #div/0! on some columns
Ive tried an iferror in from but cant get to work or its me with the syntax
Any suggestions would be appreciated
regards
Ian
=SUMPRODUCT(--(Data!$E$2:$E$20000=Summary!$A$1),--(Data!$G$2:$G$20000=Summary!$D15),--(Data!$A$2:$A$20000=Summary!F$6),Data!$J$2:$J$20000)/$E15
Ive tried an iferror in from but cant get to work or its me with the syntax
Any suggestions would be appreciated
regards
Ian
=SUMPRODUCT(--(Data!$E$2:$E$20000=Summary!$A$1),--(Data!$G$2:$G$20000=Summary!$D15),--(Data!$A$2:$A$20000=Summary!F$6),Data!$J$2:$J$20000)/$E15