Summary in Excel

  johnincrete 06:41 26 Mar 2009
Locked

I have a spreadsheet containing data on pupils. I want to summarise the number of pupils by class_ID to show the number of pupils in each class in the non-number column "Full_name" and the totals of the Euro amounts (integer)in "Month_Amt", the subtotals being on a new row at the end of each class. All rows are already color filled so a default white line will stand out.
I'm sure this simple thing is possible in Excel - it's just that I don't know how!

  ravingdave 12:30 27 Mar 2009

Insert a row at the end of each class.
If for instance your Full_names were in column C, and rows associated with that class went from 23 to 37
Then on your newly insrted row (row 38) you can use =COUNTA(C23:C37) to show the number of pupils in the class.

If month_amounts are in column F, then entering =SUM(F23:F37) will give you the total euro amount.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone