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 ru...
"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)Detlef_Lewin That works, THANK YOU!! Is there a way to program in for multiple columns in the same total? I tried =COUNTA(c3..c48)+(J3..J48)+(Q3..Q48) but just got an error message.
So, it is not counting for each child but counting for multiple children?
Since it is a secret what is in the other column I will give the long way:=COUNTA(C3:c48)+COUNTA(J3:J48)+COUNTA(Q3:Q48)