DIV/O error

G

Guest

C D E F
Jan-Mar April-Jun Jul-Sep Oct-Dec
3 3 3 0
0 1 0 0
0 1 2 0
0% 67% 67% #DIV/0!


I am trying to use the following formula to get rid of the DIV/O error in F5
=if(count(f2:f4)=0,"", otherwise sum(f3:f4)/f2.

Thank you in advance for any help you can offer
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top