=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)

#1

Thats the last Excel formula I wrote! How about yourself?

#2

=SUM(A1,A9)

don’t @ me

#3

Probably

="= blah blah"

#4

=SUM(E28:I28)

#5

ctrl+f

#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!

#7

=IF($J$12=1,E15,IF($J$12=2,E16,E17))

#8

=IFNA(INDEX(‘Featured Players’!$F$13:$F$2010,MATCH(‘Actor Stats’!E12,‘Featured Players’!$D$13:$D$2010,0)),“0”)

#9

=159395/6

#10

My boss literally asks people what their favourite spreadsheet formula is in interviews

#11

I had an employer ask what my favourite excel shortcut was once. I said Ctrl Z

#12

I mean, ask a stupid question…

#13

I said cntrl f

#14

=$C$34*($C$34/$F$34)*(C36/$F$34)*I36/10000

#15

=minifs(‘Raw answers’!B:B,‘Raw answers’!F:F,“Sales”)

Gotta love a good *ifs condition