Using IF and COUNTIF

[Denny57]

I am looking for a formula that will allow a cell to be populated with the average of a range of 7 cells but only where all cells in the range have a value greater that zero (Blank).

Example

If the value of all cells in range A1:A7 are greater than zero then return the average of the values of the cells in the range, else return zero.

Many thanks

 

[Joe4]

Try this:

=IF(COUNTIF(A1:A7,">0")=7,AVERAGE(A1:A7),0)

 

[Denny57]

=IF(COUNTIF(A1:A7,">0")=7,AVERAGE(A1:A7),0)

Thank you.. Annoyed I missed the quotation marks

 

[Joe4]

You are welcome.

Note that when you mark a post as the solution, please mark the post originally containing the solution, and not your own post acknowledging that another post is the solution.
I have updated this thread for you.