=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