I need some help trying to sum totals for different events based on horizontal and vertical criteria. I've tried doing different combinations of SUMIFS + INDEX + MATCH formulas, including transposing the data and using this one: https://stackoverflow.com/questions/56156294/how-can-i-sumif-with-horizontal-and-vertical-criteria-including-dates. But I can't get any formulas to work.

Here's what I'm trying to accomplish:

I'm trying to sum the totals for different events based on some criteria

  • channel + region
  • channel + region + date

The data is found in the "data tab" and I'm trying to sum the totals in the "dashboard" tab: https://docs.google.com/spreadsheets/d/1p3cuzamRUiUAiDXQMPG4hmoHonCM8nk44diYSariBgM/edit?usp=sharing.

I need to use REGEXMATCH to match the channel name (sem or display) and the region name (uscan, emea, japac, latam).

As you can see, the campaign name & events are vertical data and the date data is horizontal. Can I get some help on the best formula(s)s to use sum the totals for the events based on these criteria?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.