M
monza_racer
I have a spreadsheet with two rows of data for each person (Row A and
Row B). I would like to COUNT or COUNTA every other cell that contains
data (or every nth cell) in a column, in this case I'd like to count
only the Row A cells that contain data. I know this can be done with
the SUM function, but I only want a count as the result, not a sum. I
tried altering the SUM formula structure, but it doesn't carry over to
COUNT or COUNTA functioning. Is there a formula to handle this, or
must a macro be developed? Thanks.
Row B). I would like to COUNT or COUNTA every other cell that contains
data (or every nth cell) in a column, in this case I'd like to count
only the Row A cells that contain data. I know this can be done with
the SUM function, but I only want a count as the result, not a sum. I
tried altering the SUM formula structure, but it doesn't carry over to
COUNT or COUNTA functioning. Is there a formula to handle this, or
must a macro be developed? Thanks.