lilsaint01
New Member
- Joined
- Sep 6, 2019
- Messages
- 8
Good Day,
Please help me to create SUMIFS formula.
the data is on different sheets (Jan-Dec) and have multiple criteria.
i tried, but i cant figure it out.
Please help create formula in column D6 and D7 on formula sheet.
Criteria for D6 are : Months, Name, and Kg
Criteria for D7 are : Months, Name, and AMOUNT
the data for criteria can be found in sheet JAN-DEC.
1. แพ็คกล่อง --> Sheet Jan-Dec Column DI
2. ผลิตได้จริง kg. --> Sheet Jan-Dec Column Q
3. AMOUNT --> Sheet Jan-Dec Column DN
4. Month --> Sheet Jan-Dec Column B
Please check this link for the attachment file :
https://drive.google.com/file/d/12qYUVRLfcPEidMhr_gw-ndGvlPAjQGmf/view?usp=sharing
Thank you in advance ..
Please help me to create SUMIFS formula.
the data is on different sheets (Jan-Dec) and have multiple criteria.
i tried, but i cant figure it out.
Please help create formula in column D6 and D7 on formula sheet.
Criteria for D6 are : Months, Name, and Kg
Criteria for D7 are : Months, Name, and AMOUNT
the data for criteria can be found in sheet JAN-DEC.
1. แพ็คกล่อง --> Sheet Jan-Dec Column DI
2. ผลิตได้จริง kg. --> Sheet Jan-Dec Column Q
3. AMOUNT --> Sheet Jan-Dec Column DN
4. Month --> Sheet Jan-Dec Column B
Please check this link for the attachment file :
https://drive.google.com/file/d/12qYUVRLfcPEidMhr_gw-ndGvlPAjQGmf/view?usp=sharing
Thank you in advance ..