AnAppleADay
New Member
- Joined
- Jun 11, 2018
- Messages
- 9
Hi all,
I have attached a clean workbook here as a link to my OneDrive: Jazz.xlsx
Currently my value returned, is based on this formula:
=SUMPRODUCT(SUMIFS(Loading!$K$2:$K$935,Loading!$M$2:$M$935,PackTypes!$A$3:$A$12,Loading!$L$2:$L$935,D$2))
Returning the value in column K of LOADINGS sheet, while checking against the criteria for pack type (Column M) and week of arrival (Column L), and placing the value in the correct column of the main sheet 'JAZZ'
I now want to be able to EXCLUDE the container numbers (LOADINGS/Column C) which i'll add to a range on the sheet EXCLUSIONS, but i can't fathom what clause to use?!
Any ideas?
I have attached a clean workbook here as a link to my OneDrive: Jazz.xlsx
Currently my value returned, is based on this formula:
=SUMPRODUCT(SUMIFS(Loading!$K$2:$K$935,Loading!$M$2:$M$935,PackTypes!$A$3:$A$12,Loading!$L$2:$L$935,D$2))
Returning the value in column K of LOADINGS sheet, while checking against the criteria for pack type (Column M) and week of arrival (Column L), and placing the value in the correct column of the main sheet 'JAZZ'
I now want to be able to EXCLUDE the container numbers (LOADINGS/Column C) which i'll add to a range on the sheet EXCLUSIONS, but i can't fathom what clause to use?!
Any ideas?