HELP with IF function

D

David

I am trying to average 7 cells formatted to time in a
sheet. My problem is I need to exclude any values that
may be zero in the average.
Example: C10=0:00, D10=0:00, E10=2:40, F10=3:25,
G10=2:25, H10=3:18, I10=2:48. I can get the formula =IF
(C10<1,AVERAGE(D10:I10),AVERAGE(C10:I10)) To work OK my
problem is how to include the next part to say "if C10
and-or D10 is < 1 average E10:I10.

Any help would be appreciated
 
P

Peo Sjoblom

Try

=AVERAGE(IF(C10:I10<>0,C10:I10))

entered with ctrl + shift & enter
format result as time. If the cells are empty you'll get a div error so you
might want
to use something to dodge that

=IF(SUM(C10:I10)=0,"",AVERAGE(IF(C10:I10<>0,C10:I10)))
 

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