USA Canada England China Australia 2016 Q1 12 12 8 49 18 Q2 23 54 4 89 43 Q3 12 15 16 20 32 Q4 1 2 3 4 5 2017 Q1 9 8 7 6 5 Q2 10 13 15 16 20 Q3 20 22 26 28 39 Q4 21 22 10 16 18
Given the above table, how can I sum for the year of 2017 for ONLY USA and England?
I tried using an array formula below but failed.
Please Login or Register to view this content.
Formula was working with SUM and OFFSET given the ISNUMBER and MATCH formula from AlKey
Please Login or Register to view this content.
Bookmarks