Forum Discussion
Excel calculation
Hi. I have a spreadsheet. Top row is a list of dance classes which have varying costs. The first column is a list of pupils. Is there an easy way to calculate the costs for each pupil depending on whi...
Livinsc05 You'll find three of many possible variants in the attached workbook. One using MMULT with 1's for "class taken" and 0's for "class not taken". The second uses SUMPRODUCT and accepts blanks in case a class is not taken by a pupil. A third variant uses a more traditional SUMIF, and allows you to put any character/word in the matrix to indicate "class taken", as long as you use the same character/word as the criteria in the formula.
- Riny_van_Eekelen thanks - they look as though they might me what I am looking for. I'll give them a go!
