Previous Topic Next Topic

Trying to do hockey stats

Closed
restlesschicken - Sep 17, 2010 at 09:31 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 18, 2010 at 09:51 PM
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

Related:

1 response

Answer 1 / 1
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 18, 2010 at 09:51 PM
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
0