icytuvi
New Member
- Joined
- Feb 2, 2020
- Messages
- 22
- Office Version
- 2013
- Platform
- Windows
Hello everyone,
I would like to seek your help with a formula that can help sum up matching row and colum as below (I tried sumifs but did not work).
Thank you very much.
I would like to seek your help with a formula that can help sum up matching row and colum as below (I tried sumifs but did not work).
Thank you very much.
Q.xlsx | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
2 | Jan | Feb | Mar | Apr | Jan | Feb | Mar | Apr | |||||
3 | Carrot | 20 | 20 | 20 | 20 | Apple | #VALUE! | ||||||
4 | Mango | 50 | 50 | 50 | 50 | Carrot | |||||||
5 | Apple | 70 | 70 | 70 | 70 | Durian | |||||||
6 | Durian | 30 | 30 | 30 | 30 | Mango | |||||||
7 | Mango | 10 | 10 | 10 | 10 | ||||||||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H3 | H3 | =SUMIFS($B$3:$E$7,$A$3:$A$7,$G3,$B$2:$E$2,H$2) |