# Function Question

Copper Contributor

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

6 Replies

# Re: Function Question

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

# Re: Function Question

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.

# Re: Function Question

So the names are in the first row?

=COUNTA(C2:C14)

# Re: Function Question

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

# Re: Function Question

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)

# Re: Function Question

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.