Help with spreadsheet

[Pazza]

Didn't know where to post, so I posted here (if wrong section move =])

Okay, my IT teacher was off so she didnt teach us how to do this stuff

Spreadsheet
For example, I want M5 to be the total the blue square, but only the number 1's. So as the number 1 = £10.50 for the blue square, for ever number 1 it will add £10.50 to the total, so if there were 10 number 1's then M5 would end up as £105.

Then I'll just re arrange it for green and yellow myself, +rep whenever I can to anybody help.

To get the 756 already there I just did =IF(then +'s all the time).

so TY for any help =]

[scottish]

Isn't ticket prices just the £10.50?

or just do Ticket sales * price? o.0

so first one would be 6 * £10.50 o.0 lol