Forum Discussion
Function Question
I have a fairly standard spreadsheet, with names along one side and across the top. Where they intersect I have been marking with an 'X'. Is there any function/cell format that would allow for a running total at the bottom of the sheet, showing how many have been marked? For each entry on the left there are five possible ones along the top. Would ideally like to have a subtotal of each line.
"running total at the bottom of the sheet, showing how many have been marked"
"Would ideally like to have a subtotal of each line."
Do you want to kinds of total or are you not sure what you want?
And I am not sure whether running total or subtotal are actually possible regarding your setup.
- It is similar to having a row for each chore in the house, with vertical entries for each child. I would X any completed chore, and am trying to get an automatic total at the bottom for how many 'X's each child has.
So the names are in the first row?
=COUNTA(C2:C14)
