How can I avoid a #DIV/0! error in the formula below when some (not all) of the data in column D will legitimately be zero?
Cells A1-A5 = Don Hours
Cells B1-B5 = Joe Hours
Cells C1-C5 = Sue Hours
Cells D1-D5 = Total Hours (SUM(A1:C1))
Cells E1-E5 = Total Fee
Formula = SUMPRODUCT(A1:A5*E1:E5/D1:D5)
Try:
=SUM(IF(D1:D5<>0,A1:A5*E1:E5/D1:D5))
confirmed with CTRL+SHIFT+ENTER not just ENTER. You will see { } brackets appear.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Why are you posting the same question twice?
I gave an infraction for this... Thanks, XLDOriginally Posted by xld
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks