Pazza
17-11-2008, 08:54 PM
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
Spreadsheethttp://www.tehupload.com/uploads/6705892a4e9e9b1ithomework.jpg
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 =]
Okay, my IT teacher was off so she didnt teach us how to do this stuff
Spreadsheethttp://www.tehupload.com/uploads/6705892a4e9e9b1ithomework.jpg
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 =]