Hi
I have attached a file which has an AVERAGEIF formula in Rating!C3:C7
I would like to incorporate the INDIRECT function so that cells Rating!C1 and D1 set the range for the calculation. In this example I want to search between New Design Row 3 and Row 7 inclusive ONLY.
My attempt in Rating!D3 returns#REF
Where have I gone wrong?
Any help as always would be much appreciated
Try,
D3=IFERROR(AVERAGEIFS(INDIRECT("'New Design'!C"&$C$1&":C"&$D$1),(INDIRECT("'New Design'!A"&$C$1&":A"&$D$1)),Rating!$B3,(INDIRECT("'New Design'!C"&$C$1&":C"&$D$1)),">0"),0)
Formula:
Please Login or Register to view this content.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thanks for tidying that up for me, I now realise that I was missing some $ absolute values and the IFERROR for DIV#
yup glad it help youand thanks for feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks