Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formular help ?
Ok i have a set of letters in each cell in a row ie,
A B C D etc to J % be cw de dw etc to J 50 now i have the formular in place to show me in % terms how many cells have been filled over the range ie, if 5 out of the ten cells have been filled it shows a % of 50. What i am trying to do is if i fill a cell with a number instead of a letter i dont want the number to be counted as a filled cell ie A B C D etc to J % be 1/2 de dw etc to J 40 i know there must be a way but try as i might i cant find it DOH! all help much appriciated Thanks Colin xx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formular | Excel Worksheet Functions | |||
I still need help with formular? | Excel Worksheet Functions | |||
formular | Setting up and Configuration of Excel | |||
If formular | Excel Discussion (Misc queries) | |||
Need Help With A Formular | New Users to Excel |