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)
don’t @ me
="= blah blah"
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”)
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
I mean, ask a stupid question…
I said cntrl f
=minifs(‘Raw answers’!B:B,‘Raw answers’!F:F,“Sales”)
Gotta love a good *ifs condition