Trying to do hockey stats

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

is there a way to add 1 to the value of one column based on data of a cell in the same row in another column, without copying 1 and doing a paste special on the selected cells?
lets say i have A1 - A22 filled with names, then B2 - B22 tells me if they active with a certain number, and then in column C every time they are active i want to add one to the cell. is there a way to select the entire column C and have it add 1 to only the rows that are active?

thanks

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
quote
B2 - B22 tells me if they active with a certain number,
unquote

not clear. what numbers. suppose 1 is for active and 0 for not active you can do that in C2 type this formlua

=IF(B2=1,B2+1,B2)

copy down.

modify to suit you