#DIV/0 Error with IF and Average Formula

Hello

I have one problem with this formula:

=IF(COUNTA(L16, T16)=0,0,AVERAGE(L16,T16))

It gives me a #DIV/0 error where I have text in both columns. In this case I'd like to see "N/A." How do I do that? (Where I have text in one column it works as I expect—no problem.) Thanks very much!

=if(counta(a16, b16)=0,0,iferror(average(a16,b16),na()))

sorry, i replaced your cell references :

=IF(COUNTA(L16, T16)=0,0,IFERROR(AVERAGE(L16,T16),NA()))

Thanks, T. That almost works: instead of #DIV/0 error I now get #N/A. I need to make a small change, but I can't work out what.

I thought that was your expected result...then, try like this:

=IF(COUNTA(L16,T16)=0,0,IFERROR(AVERAGE(L16,T16),"NA"))

That's just what I needed—thanks! (I get confused sometimes with parentheses.)