How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Pete Your Own Question
Pete, Computer Expert
Category: Microsoft Office
Satisfied Customers: 17945
Experience:  MS Office expert
Type Your Microsoft Office Question Here...
Pete is online now
A new question is answered every 9 seconds

=SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12) how do I

This answer was rated:

=SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12) how do I make this into a if formula so that if I have a zero it shows zero?
I am Pete, and I'll be happy to assist with your question today.

The formula you require is:


Customer: replied 4 years ago.

That is not correct, the 1 I have found works is =IF(SUM(E12,H12,K12,N12,Q12)=0,"0",SUM(D12,G12,J12,M12,P12)/SUM(E12,H12,K12,N12,Q12))

Hi Jim,

Both versions of the formula will give the correct answer.

Pete and 3 other Microsoft Office Specialists are ready to help you