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
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
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:
- Trying to do hockey stats
- Battery stats reset code - Guide
- Playstation stats not working - Guide
- Orion stats download - Download - Online gaming and betting
- R6 stats - Download - Gaming tools
- Mass effect 2 weapons stats - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 18, 2010 at 09:51 PM
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
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