Forum menu
Topic starter
How do I tell it to dived by the number of cells in a row, defined by if it has value entered?
ie
ie row 5. columns M to AF are the values I want to count, but if only 6 of them have a value entered, I want it to divide by 6, if 10 values I want it to divide by 10, etc etc etc
Posted : 16/02/2018 7:51 pm
Topic starter
Got it. 😆
COUNTA(M5:AF5)
very helpful, cheers troops!
Posted : 16/02/2018 7:56 pm
You could use count or countif to count the number of cells in which a condition is met. Then divide by that.
Posted : 16/02/2018 7:58 pm