Need a google sheets expert
Budget: $10 – $30 USD
So I work in marketing for a company and am analyzing survey data from our post purchase survey. I'm trying to sumifs with multiple criteria AND ranges as these ranges will update over time.
I've been able to come up with a formula that calculates this; however, it's requiring a TON of sumifs + sumifs functions, and I'd like to resolve that so it's simple and I can update easily.
Here's what I've got thus far....
=sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"AJ Greene",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"Jon Seaton",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"iKnowAyrel",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!N:N,"AJ",'Survey Responses'!AI:AI,B3)
Etc. etc.
I've created additional tables for the following:
Discount Codes to avoid
Survey Responses within column K =
Survey Responses within column N contain
Survey Responses AA:AA Do NOT Contain
Survey Responses S:S Do NOT Contain
Each of these columns will continuously update over time, which would make updating my previous formula hell.
To top it off, I will be measuring the sum of revenue within a particular month.
Here is the spreadsheet I'm working on:
https://docs.google.com/spreadsheets/d/1vt3hTm8pVpoWUjUuHYx6GYWq2Qy6zX14mFwVKcByqOY/edit?usp=sharing
I feel like there has to be a way to do this with some array formulas, but it's hurting my head...
Thanks for any help you can provide! Travis
I've been able to come up with a formula that calculates this; however, it's requiring a TON of sumifs + sumifs functions, and I'd like to resolve that so it's simple and I can update easily.
Here's what I've got thus far....
=sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"AJ Greene",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"Jon Seaton",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!K:K,"iKnowAyrel",'Survey Responses'!AI:AI,B3)
+sumifs('Survey Responses'!D:D,'Survey Responses'!A:A,"<>AJ15",'Survey Responses'!A:A,"<>JON",'Survey Responses'!AA:AA,"<>GRIN",'Survey Responses'!S:S,"<>Paid_video",'Survey Responses'!N:N,"AJ",'Survey Responses'!AI:AI,B3)
Etc. etc.
I've created additional tables for the following:
Discount Codes to avoid
Survey Responses within column K =
Survey Responses within column N contain
Survey Responses AA:AA Do NOT Contain
Survey Responses S:S Do NOT Contain
Each of these columns will continuously update over time, which would make updating my previous formula hell.
To top it off, I will be measuring the sum of revenue within a particular month.
Here is the spreadsheet I'm working on:
https://docs.google.com/spreadsheets/d/1vt3hTm8pVpoWUjUuHYx6GYWq2Qy6zX14mFwVKcByqOY/edit?usp=sharing
I feel like there has to be a way to do this with some array formulas, but it's hurting my head...
Thanks for any help you can provide! Travis