Help with a formula for addition by month

[Rashie]

Hey All,

I've got some sample data here

https://docs.google.com/spreadsheets/d/1T6AWBgTQyFLu2G0x4LhHCx2zjNUiXCG5i_lVTNX8X-8/pubhtml

I'm renewing an existing tracker we use for 2016 and thought I could spruce it up a bit but I'm stuck with a few formulas.
All the blank orange boxes at the top for spend per month etc were been entered manually and this was leading to errors. I'm hoping that you can help so they're filled in automatically based on "Month of travel" column , i.e. any bookings made to travel in JAN will automatically fill out

<colgroup><col style="width: 109px"></colgroup><tbody>
[TD="bgcolor: #C0C0C0"]PASSENGERS BOOKED BY MONTH[/TD]

[TD="bgcolor: #C0C0C0"]SPEND BY MONTH[/TD]

[TD="bgcolor: #C0C0C0"]PROFIT/LOSS BY MONTH[/TD]

</tbody>

But i'm at a total loss and a little help would be appreciated!

Thanks in advance,

Rashad.

 

[Special-K99]

Why are all your departure dates for 2015 but the orange boxes have months for 2016?
Or am I misunderstanding the spreadsheet?

 

[Rashie]

Sorry, that's on oversight from me. I've used last year's data to make the sample.
I'll amend it on the google sheet.