Can SUMPRODUCT be used to calculate monthly costs?

Hello again,

Thank you to everyone who helped me with this issue earlier this week.

I now want to calculate the monthly cost for the room hire, and I'm guessing that SUMPRODUCT can be used for this too, but I can't work out how to write the formula so that it is referring both to the month and the cost. Apologies again for the elementary nature of this question. I've attached the spreadsheet.

Try this in O2 and copy down:

Formula:

Please Login or Register  to view this content.

or

Formula:

Please Login or Register  to view this content.

BSB

Brilliant! Thank you BadlySpelledBuoy.

No problem. Happy to help
Thanks for the rep point.

BSB