Function Question

Copper Contributor

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.

6 Replies

@KeithleyNotary 

"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.

@KeithleyNotary 

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)
No real secret, just hiding my nerd side...lol. It is a spreadsheet tracking my weapon camos in CoD. The different columns are for different weapon classes. I figured the kid/chore analogy would be easier to visualize. I will try the one you just set, thank you again.