I am trying to write an IF Function in excel to divide by an inconsistent subtotal cell. If cell B1 is greater than 0. I want it to divide B1 by b3(which is the subtotal, but each section has a different amount of lines.
b1 c1
Qty Stocking U/M
30.00 ? IF
30.00
b1 c1
Qty Stocking U/M
30.00 ? IF
30
30
90.00
Can anyone please help?
b1 c1
Qty Stocking U/M
30.00 ? IF
30.00
b1 c1
Qty Stocking U/M
30.00 ? IF
30
30
90.00
Can anyone please help?