Using the formula =AVERAGEIFS(WORKSHEET!V5:V35,WORKSHEET!B5:B35,">=A43",WORKSHEET!B5:B35,"<=C43") returns a #DIV0! error. I need to average the numbers in column V that fall into the date range between cells A43 and c43. The problem appears to be with using ">=A43" and "<=C43" because if i substitute numbers for the cell reference it works.
Last edited by John007; 01-10-2012 at 05:28 PM.
Use ">="&A43, etc
Regards, TMS
Hello John,
you are almoste there. Just change the formula to,
=AVERAGEIFS(WORKSHEET!V5:V35,WORKSHEET!B5:B35,">="&A43,WORKSHEET!B5:B35,"<="&C43)
If you use cell references inside the quotes, this will consider as text NOT cell references.
HTH; Haseeb
If your problem is solved, please say so clearly, and mark your thread as Solved:
Forum Rules & How to Mark a thread as SOLVED
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks