Ok. This is what I want to be able to do.
lets say I have 10 cells.... say A1 to A10... now in each of those cells there may or may not be a value... any value....a letter or number... whatever.
Now lets say in cell B1 I want it to tell me how many of the cells in A1 to A10 have values in them.... so say in a1 is 200...... a2 is 5..... a6 is 50... and all the other ones are blank..... I want B1 to automatically display 3.
How would I do that?
lets say I have 10 cells.... say A1 to A10... now in each of those cells there may or may not be a value... any value....a letter or number... whatever.
Now lets say in cell B1 I want it to tell me how many of the cells in A1 to A10 have values in them.... so say in a1 is 200...... a2 is 5..... a6 is 50... and all the other ones are blank..... I want B1 to automatically display 3.
How would I do that?
via JREF Forum http://ift.tt/1nQORQD
Aucun commentaire:
Enregistrer un commentaire