I am trying to create an excel formula that will increase a number in a cell by 1 when a specific number is entered in cell a14. In my worksheet I have 10 colours listed, each with a number from 1 to 10. What I am trying to do is be able to type a number from 1 to 10 in cell a14 and for it to then count up by 1 in the cell next to the corresponding colour, which will be cells c3 to c12. We ran a vote at work and I need to be able to log how many votes each colour received. The link below is to a screenshot of my worksheet.
This Formula is a circular reference formula you should change the options in Excel Formulas:
Click on Enable Iterative Calculation and change
the Maximum Iterations to 1
and the formula will work drag it down under Vote and whatever you write in A14 the formula will look to the same number under # in Column A and add 1 in the corresponding row (color) in column C.
Check first if Excel has the option of Iterative Calculation.