Hi Fiona,

To count cells that contain a formula that returns a value and exclude those that return a blank, you can use the

Formula:

COUNTIF 


function in combination with the

Formula:

IF 


function.

Here are the steps:

1. Select the cell where you want to display the count result.
2. Type the following formula:
   Formula:

   =COUNTIF(range,"<")+COUNTBLANK(range)-COUNTIF(range," ") 

   
   - Replace "range" with the actual range of cells you want to count.
   - The "<" symbol means "not equal to", so the formula will count cells that are not blank or do not contain a space character.
   - The
   Formula:

   COUNTBLANK 

   function counts the number of blank cells in the range.
   - The "-
   Formula:

   COUNTIF(range," ") 

   " part subtracts the number of cells that contain a space character.
3. Press Enter to display the result.

This formula should give you the desired count result. Let me know if you have any questions or if there's anything else I can help you with.