I'm a little bit stuck trying to create a formula for a spreadsheet that I am working on.
I am trying to simplify data I have collected in a table into two cells, what I need to do is have the value of the cell I have marked x to increase by +1 (starting from 0) for each green cell with a 1 in it on each row (the x value for each week is based on the number of green cells with a 1 in them on that row)
I also would like for the value of the cell I have marked y to increase by +1 (starting from 0) for each red cell with a 2 in it on each row. The colour of the cells is irrelevant to the formula I would only like for the cell values to be used in the formula.
Any help on this would be greatly appreciated
Here is the worksheet I am working on.
I am trying to simplify data I have collected in a table into two cells, what I need to do is have the value of the cell I have marked x to increase by +1 (starting from 0) for each green cell with a 1 in it on each row (the x value for each week is based on the number of green cells with a 1 in them on that row)
I also would like for the value of the cell I have marked y to increase by +1 (starting from 0) for each red cell with a 2 in it on each row. The colour of the cells is irrelevant to the formula I would only like for the cell values to be used in the formula.
Any help on this would be greatly appreciated
Here is the worksheet I am working on.
Football Balance Sheet.xlsx
B C D E F G H I J K L M N O P Q R S T U V W X Y Z 3 1 02/12/2022 1 1 2 2 1 1 1 1 1 7 2 4 2 09/12/2022 1 1 1 2 2 2 1 1 1 1 1 1 9 3 5 3 16/12/2022 1 1 1 1 x y 6 4 23/12/2022 1 1 1 x y 7 5 30/12/2022 1 1 1 x y 8 6 06/01/2023 1 1 1 x y 9 7 13/01/2023 1 1 1 x y 10 8 20/01/2023 1 1 1 x y 11 9 27/01/2023 1 1 1 x y 12 10 03/02/2023 1 1 1 x y Dec-Feb 2023
| Football Balance Sheet.xlsx | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |||
| 3 | 1 | 02/12/2022 | 1 | 1 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 7 | 2 | ||||||||||||||
| 4 | 2 | 09/12/2022 | 1 | 1 | 1 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 9 | 3 | |||||||||||
| 5 | 3 | 16/12/2022 | 1 | 1 | 1 | 1 | x | y | |||||||||||||||||||
| 6 | 4 | 23/12/2022 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 7 | 5 | 30/12/2022 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 8 | 6 | 06/01/2023 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 9 | 7 | 13/01/2023 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 10 | 8 | 20/01/2023 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 11 | 9 | 27/01/2023 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
| 12 | 10 | 03/02/2023 | 1 | 1 | 1 | x | y | ||||||||||||||||||||
Dec-Feb 2023 | |||||||||||||||||||||||||||
