HansV wrote: ↑17 Dec 2020, 19:27

Use:

=IFERROR(AVERAGE(B3:B39),"")

Hans everything is working great thanks to you but I would like to ask a question for my education. I had other formulas in the spreadsheet and thought if I followed your examples I could figure them out. Well I did get them working. I had a need to use the =MAX and =MIN functions. I got them to work using:

**=(IF(MAX(B3:B39)<>0,(MAX(B3:B39)),""))**

=(IF(MIN(B3:B39)<>0,(MIN(B3:B39)),""))
These gave me the blank cells I wanted.

I tried using the =IFERROR, as you did in the =AVERAGE function, and that still gave a 0, not a blank cell as I wanted.

I'm not sure the functions I listed above that I came up with are the correct ones or best ones to use but they seem to work. Why didn't the =IFERROR work?

By the way, before I asked for your help I used the same function syntax for the =AVERAGE function,

**"=(If(Max(B3:B39)<>0,(Max(B3:B39)),""))"** and it too did not give me a blank cell.

Just curious when I should use the =IFERROR or the <>0 type of syntax.

Sure hope I phrased this so you can understand what I'm asking.

Thanks