count if / average only when a value is present

Hi All,

Trying to count if only when there is a value present on the SP page. I'm trying to show the average of the numbers (will weight afterwards) onto the Summary page for each qtr and month.

This is what I have now but can't seem to figure out why it doesn't work.

=IF(COUNT(SP!C3:E5),AVERAGE(SP!C3:E5),"")

Thanks for your help.