| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count blank cells that contain formula?
I am trying to count blank cells in a column that contain a formula, but when
I do excel counts the formulas as well even though they are blank... Currently my formula looks like: =IF(B43=INDIRECT("Medicaid_Medical!"&I43&"$2"),COU NTA(OFFSET(INDIRECT("Medicaid_Medical!"&I43&"$2"), 2,0,47,1))/COUNTA(States_Medical),0) The problem is the cells in the column it is counting contain an if statement to see what cells are blank. Any way to look over the blank cells and keep the if statement? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count interstitial blank cells? | Excel Discussion (Misc queries) | |||
| How can I count conditional blank cells? | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| formula to count cells not blanK | Excel Worksheet Functions | |||
| Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Threaded Mode
