G
Guest
Guest
Good Day All,
I am a beginner Excel user who has been assigned a daunting task.
My spreadsheet will be used to calculate course cost per division (I have 5 divisions).
I have colour codes cells to denote which division a student is with in A4:A30. I have entered a cost for the course in I14.
In a cell I want to calculate how much each division owes based on the number of each coloured cell in the column multiplied by the course cost.
Any simple ideas (I'll even take more advanced ideas as I feel I'm getting the hang of some oft his stuff).
Thank you all so much for your consideration!
I am a beginner Excel user who has been assigned a daunting task.
My spreadsheet will be used to calculate course cost per division (I have 5 divisions).
I have colour codes cells to denote which division a student is with in A4:A30. I have entered a cost for the course in I14.
In a cell I want to calculate how much each division owes based on the number of each coloured cell in the column multiplied by the course cost.
Any simple ideas (I'll even take more advanced ideas as I feel I'm getting the hang of some oft his stuff).
Thank you all so much for your consideration!