kumara_faith
Well-known Member
- Joined
- Aug 19, 2006
- Messages
- 922
- Office Version
- 365
Hi,
I have the following tables:
I have my data table in Table 1 and summary in table 2.
I am trying to summarize the sales for Alex for the month of January using a SUMIFS but it is not showing the correct result. The correct result is in Table 3. Appreciate any help. Thanks
I have the following tables:
Book3 | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | |||
2 | Table 1 | Table 2 | Table 3 | ||||||||||||||
3 | Date | Month | Staff | Branch | Sales | Month | Staff | Branch | Sales | Month | Staff | Branch | Sales | ||||
4 | 1/1/2022 | Jan | Alex | England | 10 | January | Alex | England | 0 | January | Alex | England | 15 | ||||
5 | 1/1/2022 | Jan | Joe | North America | 0 | ||||||||||||
6 | 1/1/2022 | Jan | Alex | England | 5 | ||||||||||||
7 | 1/1/2022 | Jan | Mina | Singapore | 10 | ||||||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L4 | L4 | =SUMIFS(G4:G7,D4:D7,I4,E4:E7,J4,F4:F7,K4) |
I have my data table in Table 1 and summary in table 2.
I am trying to summarize the sales for Alex for the month of January using a SUMIFS but it is not showing the correct result. The correct result is in Table 3. Appreciate any help. Thanks