Ian Bell
asked on
Modify div by zero error formula
Hi,
I'd like a formula modified to ignore blank cells or zero cells when target cells are a negative value.
Please see attached for example.
Many Thanks
Ian
divbyzeroerror.xlsx
I'd like a formula modified to ignore blank cells or zero cells when target cells are a negative value.
Please see attached for example.
Many Thanks
Ian
divbyzeroerror.xlsx
=SUMPRODUCT(((0&B3:F3)*(B1 :F1>=0))^A BS(B$1:F$1 ))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Nice job again Saqib. Thanks a million.
Ian
Ian