Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- =AVERAGE(query(""&B1&""&C1&"!!A2:I","Select Col9 where Col2='"&A5&"'"))
- =AVERAGE(query('2019年5月'!A$2:I,"Select I where B='"&A5&"'"))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement