Adding Date Range to Averageif statement
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
|