Forum Discussion
Solved
How to use the numbers in a formula
Hi I have the formula =AVERAGE(P230:P235) which works. I'd like to be able to apply a conditional format to show that the range is 6 cells or have another cell that shows the number 6, i.e. how ma...
Hi Chris,
Please check attached, I added function and formula, it is 6 in R54
Have you tried using one of these functions?
COUNT
COUNTA
They work just like AVERAGE funtion
Nope, wrong kind of thing. I want it to show that there are six cells being summed.
I'm afraid there is no biscuit for that :)