Hello,
I am trying to sum two columns where multiple AND/OR criteria is met. Currently, the SUMIFS formulae I'm using contain excessive repetitions of syntax and I'm certain there must be a more concise method.
Please see attached sample data.
I want to sum the AMOUNT1 and AMOUNT2 columns where
TYPE = "a" or "b", and
CHANNEL = "y" or "z", and
COUNTRY = "UK" or "GB"
In the sample data I attach, by filtering for the above, the sum comes to 40.45.
Thanks,
Katie
Bookmarks