Ok Ive worked out where i was going wrong with the syntrax of the formula, and this is what ive got so far:
But Excel doesnt seem to like the B5:B51 part of the Formula, and also at the moment the formula (if it works) will just change the cell value to 1 and not Add 1 to it, +1 doesnt work? What would be the correct way to put it?
what your trying to do is count the number of 3's in the B column?
If so: =CountIf(B:B,3)
You cannot tell excel to add one to another cell, you must do that in VBA code not a formula. But this formula, i think, is what you are looking for. (paste it on your sheet somewhere to see if it works)