Hi,
I am using the below mentioned formula which is taking long time to calculate. Can someone please help in letting me know where I am going wrong?
SUMIFS(Data!$S$2:$S$45961,Data!$P$2:$P$45961,$B23,Data!$G$2:$G$45961,$C$4,IF($B$3="SASIA",Data!$C$2:$C$45961,Data!$B$2:$B$45961),$B$3,IF($B$2="WITHIN RANGE",Data!$AA$2:$AA$45961,Data!$Z$2:$Z$45961),$B$2,Data!$J$2:$J$45961,$B$22)/1000
Thanks,
Aashish
Bookmarks