adding average to a sumproduct/sumif statement

HI-

I want to add average to

Please Login or Register  to view this content.

Below is my full formula

Please Login or Register  to view this content.

Do you mean this:

="Average is " & TEXT(SUMPRODUCT((Turnover!$B$4:$B$15="MTD")*(Turnover!$H$4:$H$15))/SUMPRODUCT((Turnover!$B$4:$B$15="MTD")*(Turnover!$E$4:$E$15)),"0.00")

Hope this helps.

Pete

that doesn't work, and I don't want the average of the whole formula, I just want the average values of (Turnover e4:e15)

Use this, then:

=AVERAGE(Turnover!$E$4:$E$15)

Hope this helps.

Pete