ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Need a formula for cells B2, B3, B4, etc. (https://www.excelbanter.com/excel-worksheet-functions/8665-need-formula-cells-b2-b3-b4-etc.html)

Fuzzy Odie

Need a formula for cells B2, B3, B4, etc.
 
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


All times are GMT +1. The time now is 09:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com