ExcelBanter - DIV/O error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - DIV/O error (https://www.excelbanter.com/excel-discussion-misc-queries/139518-div-o-error.html)

ferde

DIV/O error

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

JE McGimpsey

DIV/O error

One way:

=IF(F2=0,"",SUM(F3:F4)/F2)

In article ,
ferde wrote:

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

All times are GMT +1. The time now is 07:12 AM.