Melbourne Client List

The calculation D$6>69,$"Over $69$ will return

Over $69$

$69$

FALSE

Blank$/$Nothing

FALSE

FALSE

FALSE

FALSE

Which formula returns the total above average last year spend for the Northern Metropolitan?

$=$SUMIFS$($J$6$:J$15,$J$6$:J$15,>$N$13,$E$6$:E$15,$"Northern Metropolitan"$)$

$=$ SUMIFS$($J$6$:J$15,$E$6$:E$15,$M$6,$J$6$:J$15,">"$&N$13)$

$=$ SUMIF$($J$6$:J$15,$J$6$:J$15,>=$N$13,$E$6$:E$15,$M$6)$

$=$SUMIF$($J$6$:J$15,$E$6$:E$15,$"Northern Metropolitan",J$6$:J$15,">$N$13")$

FALSE

FALSE

FALSE

FALSE

Which of the following is the correct formula to return the Last Year Spend for the client at postcode $3055?$

$=$ VLOOKUP$(3055,B$$$6$:$K$$$15,9,$FALSE$)$

$=$ VLOOKUP$(3055,$$$B$$$6$:$$K$$$15,9,1)$

$=$ VLOOKUP$(3055,$$$F$$$6$:$$K$$$15,5)$

$=$ VLOOKUP$(3055,F6$:$K15,5,0)$

FALSE

FALSE

FALSE

FALSE