![]() |
Counting Non Blank Cells that Contain Formulas
Is there a way to count cells that contain formulas, but only those cells
that return a value. I tried using COUNTA...but that sees the ceel as nonblank also. |
Counting Non Blank Cells that Contain Formulas
If formulas return text...
=COUNTIF(Range,"?*") or numbers: =COUNT(Range) jimswinder wrote: Is there a way to count cells that contain formulas, but only those cells that return a value. I tried using COUNTA...but that sees the ceel as nonblank also. |
All times are GMT +1. The time now is 09:22 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com