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.
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.
Riny_van_Eekelen Thanks so much my friend, that's perfect!