Advertisement
Guest User

Untitled

a guest
Aug 16th, 2018
69
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.44 KB | None | 0 0
  1. =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