Adding Date Range to Averageif statement
You can do that like this:
=AVERAGE(IF(('MRR Log'!O8:O1769="Open")*(TEXT('MRR Log'!D8:D1769,"mmm-
yy")="Jun-08"),'MRR Log'!Q8:Q1769))
assuming your dates are in column D. This will check for June 2008,
but hopefully you can see how to change it for different months.
Remember to use CSE to commit the formula after editting it.
Hope this helps.
Pete
On Oct 3, 2:29*pm, lwilliams
wrote:
I am using the following statement to calculate an average value for a
specific status of a data set. *I need to add an additional expression to
calculate by month and by quarter in addition to the status. *Even thought I
am using Excell 2007, the calculation has to work on Excel 2003.
{=AVERAGE(IF('MRR Log'!O8:O1769="Open",'MRR Log'!Q8:Q1769))}
Thanks in advance for any help.
--
Larry
|