Need a formula

Md Zahirul Islam

New Member
Joined
Aug 30, 2023
Messages
2
Office Version
  1. 2019
Platform
  1. Windows
12345678
Product Name
120101026​
Single Bite Beef Samosa 250 gm
15​

250​

201​

15.39​
30.0030.78
120102040​
Deshi Paratha (Family Pack) 1300 gm [L]
6​

1300​

239.5​

15.39​
120.00307.81

120102043​
Premium Deshi Paratha 1300 gm [L]
6​

1300​

244.5​

15.39​
180.00461.71

120104014​
Dal Puri 454 gm [L]
20​

454​

109.5​

21.318​
40.0042.64

120104015​
Aloo Puri 454 gm [L]
20​

454​

103​

21.318​
40.0042.64

120105014​
Vegetable Spring Roll 400 gm [L]
18​

400​

112.75​

21.318​
36.0042.64

120105016​
Mini Chicken Spring Roll 300 gm [L]
20​

300​

182.75​

17.528​
40.0035.06

120106016​
Mini Singara 300 gm [L]
24​

300​

95.75​

28.536​
48.0057.07

120108019​
French Fries (Straight Cut) 500 gm [L]
16​

500​

113.5​

28.536​
240.00428.04

120108020​
French Fries (Straight Cut) 1 Kg [L]
8​

1000​

199.75​

28.536​
24.0085.61

120112002​
Chicken Momo 250 gm
20​

250​

188​

17.528​
30.0026.29

120112003​
Chicken Wonthon 300 gm
20​

300​

173​

17.528​
30.0026.29

120201023​
Chicken Nuggets 300 gm [L]
24​

300​

191.5​

21.318​
144.00127.91

120202014​
Chicken Sausage 340 gm [L]
36​

340​

209​

21.318​
144.0085.27

120204003​
Sweet & Hot Wings and Drumlets 500 gm
14​

500​

268​

17.528​
70.0087.64

120205004​
Chicken Strips 300 gm
16​

300​

221.5​

17.528​
32.0035.06

120206005​
Pop Chicken 250 gm
25​

250​

203.5​

17.528​
50.0035.06

120207010​
Chicken Meat Ball 400 gm
24​

400​

232.5​

21.318​
48.0042.64

120301008​
Fish Ball 200 gm
42​

200​

147​

28.536​
84.0057.07
Total =1,430.00
Kg820.38
Amount263,312.00
Ltr2,057.20


[TR]



I have need (7/3)*6=
and last raw of 7th cloumn (2057.20) into last raw of 6th cloumn in one fomula.
 
Last edited by a moderator:

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
1693453399856.png
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top