Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"") + SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"0") + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"1")/2) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"2")/3) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"3")/4) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!B:B,C33,'Sea Monster Loot'!Q:Q,"4")/5) + SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"") + SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"0") + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"1")/2) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"2")/3) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"3")/4) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!R:R,C33,'Sea Monster Loot'!Q:Q,"4")/5) + SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!S:S,C33,'Sea Monster Loot'!Q:Q,"") + SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!S:S,C33,'Sea Monster Loot'!Q:Q,"0") + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!S:S,C33,'Sea Monster Loot'!Q:Q,"1")/2) + (SUMIFS('Sea Monster Loot'!V:V,'Sea Monster Loot'!A:A, ">="&A33,'Sea Monster Loot'!A:A, "<="&B33, 'Sea Monster Loot'!S:S,C33,'Sea Monster Loot'!Q:Q,"2")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement