Thats the last Excel formula I wrote! How about yourself?
=SUMIFS('Actual Table'!G:G,'Actual Table'!$B:$B,AE!$A9,'Actual Table'!$D:$D,AE!$A$4)+SUMIFS('Manual Additions'!G:G,'Manual Additions'!$B:$B,AE!$A9,'Manual Additions'!$D:$D,AE!$A$4)
Balonz
#6
=IF(I19<>0,IF(D19<=I19,IF(I19>0,D19/I19,-1-(D19-I19)/I19),IF(D19>=I19,IF(I19>0,D19/I19,(1+((D19-I19)/(I19*-1)))),D19/I19)),0)
Oh I didn’t write that, but it is the last I c&p… and it isn’t in excel. Sorry!
=IFNA(INDEX(‘Featured Players’!$F$13:$F$2010,MATCH(‘Actor Stats’!E12,‘Featured Players’!$D$13:$D$2010,0)),“0”)
chanticleer
#15
=minifs(‘Raw answers’!B:B,‘Raw answers’!F:F,“Sales”)
Gotta love a good *ifs condition