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

jordan_229 · 2018-03-27T10:10:52.554Z

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

Epimer · 2018-03-27T10:12:22.493Z

=SUM(A1,A9)

don’t @ me

1101010 · 2018-03-27T10:12:27.789Z

Probably

="= blah blah"

AQOS · 2018-03-27T10:12:59.821Z

=SUM(E28:I28)

Ruffers · 2018-03-27T10:14:12.078Z

ctrl+f

anon29812515 · 2018-03-27T10:14:23.207Z

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

jont2001 · 2018-03-27T10:18:06.479Z

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

silentcommand · 2018-03-27T11:05:35.661Z

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

eems · 2018-03-27T11:06:33.462Z

=159395/6

Ruffers · 2018-03-27T11:11:25.884Z

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

Scott_Chegg · 2018-03-27T11:15:49.584Z

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

Scott_Chegg · 2018-03-27T11:16:29.311Z

I mean, ask a stupid question…

Ruffers · 2018-03-27T11:18:24.478Z

I said cntrl f

rob.orch · 2018-03-27T11:32:48.298Z

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

chanticleer · 2018-03-27T11:40:36.324Z

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

Gotta love a good *ifs condition