0

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?

1

0

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.