Mallikarjuna Reddy G
New Member
Am trying to obtain sumproduct of two rows having data (One of rows may have zeros and the other row is the derived value of each row value divided by itself)
Ex Data:
ROW 1 ROW 2
100 0
30 30
400 30
500 30
USED FORMULA:
=SUMPRODUCT(F4:F7,G4:G7/G4:G7)
ERROR :
#DIV/0!
Please help on this ....
Ex Data:
ROW 1 ROW 2
100 0
30 30
400 30
500 30
USED FORMULA:
=SUMPRODUCT(F4:F7,G4:G7/G4:G7)
ERROR :
#DIV/0!
Please help on this ....