Dexir
New Member
- Joined
- Oct 27, 2018
- Messages
- 38
- Office Version
- 2016
- 2013
- Platform
- Windows
Hi Experts, Greetings!
I have this sheet, sumif is working fine, but i want to get the quantity of A Range and B Range in F2 and F3, if i do filter any specific packing. Thanks in advance.
I have this sheet, sumif is working fine, but i want to get the quantity of A Range and B Range in F2 and F3, if i do filter any specific packing. Thanks in advance.
Book1 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | |||||||||
2 | A RANGE | 174 | |||||||
3 | B RANGE | 307 | |||||||
4 | Packing Size | Range | Qty | ||||||
5 | 30X30 | B RANGE | 20 | ||||||
6 | 15X15 | A RANGE | 26 | ||||||
7 | 18X24 | A RANGE | 27 | ||||||
8 | 30X30 | B RANGE | 28 | ||||||
9 | 15X15 | B RANGE | 90 | ||||||
10 | 18X24 | B RANGE | 40 | ||||||
11 | 30X30 | B RANGE | 80 | ||||||
12 | 15X15 | B RANGE | 49 | ||||||
13 | 30X30 | A RANGE | 61 | ||||||
14 | 15X15 | A RANGE | 48 | ||||||
15 | 15X15 | A RANGE | 12 | ||||||
16 | |||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F2 | F2 | =SUMIF($B$5:$B$15,$E$2,$C$5:$C$15) |
F3 | F3 | =SUMIF($B$5:$B$15,$E$3,$C$5:$C$15) |