Example I Example II
A2-A4 B2-B4 A2-A4
B2-B4
Qty Rec'vd Total Sold Qty Rec'vd
Total sold
4 4(=A6:A8) 4
3(=A6:A8)
3 2(=A6:A8-B2) 3
0(=A6:A8-B2)
2 0 2
0
A6-A8 A6-A8
Qty Sold Need formula for cells B2, Qty Sold
2 B3,B4 that wil work for both 3
3 examples on the same sheet. 0
1 0