| A | B | C | D | E | F | G | H |
1 | Product Code | Poduct Name | Quntity | Product Price | Price | Product Code | TProduct Quantity | TP Price |
2 | RDL | Rahar Ki Dal | 5 | 85 | 425 | RDL | 390 | 31950 |
3 | CDL | Chane Ki Dal | 10 | 65 | 650 | CDL | 30 | 1750 |
4 | MDL | Matar Ki Dal | 15 | 45 | 675 | MDL | 60 | 2475 |
5 | MDL | Matar Ki Dal | 45 | 40 | 1800 | MSUDL | 130 | 12450 |
6 | RDL | Rahar Ki Dal | 20 | 70 | 1400 | BKT 100 | 325 | 4225 |
7 | RDL | Rahar Ki Dal | 15 | 75 | 1125 |
|
|
|
8 | CDL | Chane Ki Dal | 20 | 55 | 1100 |
|
|
|
9 | MSUDL | Masur Ki Dal | 50 | 95 | 4750 |
|
|
|
10 | MSUDL | Masur Ki Dal | 30 | 90 | 2700 |
|
|
|
11 | RDL | Rahar Ki Dal | 100 | 90 | 9000 |
|
|
|
12 | RDL | Rahar Ki Dal | 50 | 80 | 4000 |
|
|
|
13 | MSUDL | Masur Ki Dal | 50 | 100 | 5000 |
|
|
|
14 | BKT 100 | Bail Kolhu Tel | 100 | 15 | 1500 |
|
|
|
15 | BKT 100 | Bail Kolhu Tel | 25 | 13 | 325 |
|
|
|
16 | RDL | Rahar Ki Dal | 200 | 80 | 16000 |
|
|
|
17 | BKT 100 | Bail Kolhu Tel | 200 | 12 | 2400 |
|
|
|
|
|
|
|
|
|
|
|
|
g2 = =SUMIF(A:A,F2,C:C)
h2 = =SUMIF(A:A,F2,E:E)
Note =
=sumif(range, criteria, [sum_range])
This is a free homepage created with page4. Get your own on www.page4.com