Average with Condition
Thanks
Can you help with a condition that does not include days where there are no
sales
thanks again
--
ce
"Paul C" wrote:
In Excel 2007 there is a AVERAGEIF function (look it up in help) that should
do the trick
If you are in Excel 2003 this is not available but you can still achieve
your result by doing a conditional sum and dividing by the number of days
like this
=SUMIF(Sheet1!B9:B39,"=" & B10,Sheet1!AE9:AE39)/COUNTIF(Sheet1!B9:B39,"="
& B10)
--
If this helps, please remember to click yes.
"Curtis" wrote:
I have a report sheet where
Cell b10 represent the day of the month
I need a formula that will look to a prior month sheet for the corresponding
day as identified in B10 and average the sum sales to that point
In the source sheet
Column B (rows 9 thru 39) = day of month
Column AE (row 9 thru 39) = sales
--
ce
|