Forum Discussion
Solved
How to Average Sales Data based on a matching date
How to Average Sales Data based on a matching date Good morning all! Hello from Ontario Canada! I've got a multi data sheet here and I'm trying to get the worksheet to calculate a gross average...
ALLENCANADA See attached. Perhaps that helps.
ALLENCANADA You should AVERAGEIF in B7 as demonstrated in the picture below. Not sure what you wan tin the other cells as the just show REF errors.
Thanks so much! This is definitely what I'm after, I forgot to mention that I also wanted to sort by 'Deal Tracking' D7-D300 "NEW".
I'm trying to change it to AVERAGEIFS but it's not accepting the additional criteria 😞
ALLENCANADA You indeed need AVERAGEIFS.
Try this:
=AVERAGEIFS('Deal Tracking'!R7:R300,'Deal Tracking'!B7:B300,B2,'Deal Tracking'!D7:D300,"New")- Thanks for working on this, that formula seems to render a value of 'true' though.
ALLENCANADA See attached. Perhaps that helps.
Try
=AVERAGEIFS('Deal Tracking'!R7:R300, 'Deal Tracking'!B7:B300, B2, 'Deal Tracking'!D7:D300, "NEW")
Note that the range to average is now the first argument.
