kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 955
- Office Version
- 365
Hi,
I have the following formula which excel keep saying error in formula. Am I missing any brackets here ? Appreciate any help.
I have the following formula which excel keep saying error in formula. Am I missing any brackets here ? Appreciate any help.
Excel Formula:
=IFERROR(((F41*$F$3)+(G41*$G$3)+(H41*$H$3)+(I41*$I$3)+(J41*$J$3)+(K41*$K$3)+(L41*$L$3)+(M41*$M$3)+(N41*$N$3)+(O41*$O$3)+(P41*$P$3)+(Q41*$Q$3)+(R41*$R$3)+(S41*$S$3)+(T41*$T$3)+(U41*$U$3)+(V41*$V$3)+(W41*$W$3)+(X41*$X$3))/((XLOOKUP(Jan!E41,'Lookup Tables'!$AD$3:$AD$17,'Lookup Tables'!$AE$3:$AE$17))*(COUNTIF(Y7:Y40,">0%")),0))))