Ticket Prices: Date Ranges

[Swerly]

I am trying to calculate how much someone needs to pay me, where the ticket prices are set for a certain period.

I have already have help to get this far, but I'm struggling to work out why the formula would work in Office365 and not Office 2013

In Cell F2 =SUMPRODUCT(INDEX($C$8:$C$10,MATCH(ROW(INDEX($ZZ:$ZZ,A2):INDEX($ZZ:$ZZ,B2)),$A$8:$A$10)))*E2

I'm using Excel 2013, and the above formula takes the price between the range e.g. 14/11/2019 = £2.50 and multiplying it by the number of guests, but ignoring the price change on the 16/11/2019

When I do this in Office365 the formula works as expected.

 

[DRSteele]

I suspect that you need to invoke the formula in Office 2013 with Ctrl+Shift+Enter instead of just Enter because the MATCH portion is reporting an array. I think, anyway.

 

[Swerly]

Thank you for your response.
I did try that, but I didn’t see anything change.