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

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


don’t @ me

1 Like


=“= blah blah”


1 Like



Oh I didn’t write that, but it is the last I c&p… and it isn’t in excel. Sorry!


1 Like

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


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

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

1 Like

I mean, ask a stupid question…

I said cntrl f

1 Like


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

Gotta love a good *ifs condition