Recover Lost Data with MicroSD Card Recovery : Fast Solution to Problem: Averageif date is less than today

Averageif date is less than today

I need to run a Month to Date average of units run each day.   I have a Macro that sets up each months worksheets. I would like to have a formula that will give me a percent average each day for the Month to Date. I want each day to only use the current
date and the previous days of the month.

B37 = Date   08-07
F37 = current days percentage of units run    87.1%
$H$2 = current working day    5

I have tried this formula with a few variations but I get a #Value   error. I know that is a mismatched data error but I am stumped on where to go now and I really think I am overlooking the obvious.

=Averageif(B37,"
Thanks for any help you can give me.

Cindy

Anwsers to the Problem Averageif date is less than today

Download SmartPCFixer for Free Now

Cindy,
Because AVERAGEIF can't be used in a 3D reference, one alternative would be to pull the data from each sheet's F37 cell into a table on your data analysis sheet, and then do the average from the table.
Continuing with the August 2012 example, I'm assuming there's a sheet for each weekday (Mon-Fri).
So you could form a table as follows, formatting column B as text, and typing a space before each 08:

      A                       B            C
1   DAY                  DATE   WORKDAY
2   Wednesday     08-01    1
3   Thursday          08-02    2
4   Friday                08-03    3
5   Monday             08-06    4
6   Tuesday           08-07    5
7   Wednesday     08-08    6
:           :                      :         :
23 Friday               08-31   23

In column D you can pull in the F37 values with this formula e.g.
in D2
=INDIRECT("'" & A2 & B2 & "'!F37")

And then the average formula would be
=AVERAGEIF(C2:C23,"<=" & H2,D2:D23)

where H2 holds, as you've indicated, the current workday number (assuming you have a formula for deriving this).

Hope that's something close to what you need.
___________
Regards, Tom

Open Action Center by clicking the Start button Picture of the Start button, clicking Control Panel, and then, under System and Security, clicking Review your computer's status.

Update and run your antivirus software. Windows doesn't come with antivirus software, but Action Center can often monitor the antivirus software that you or your computer manufacturer have installed.

Recommended Method to Repair the Problem: Averageif date is less than today:

How to Fix Averageif date is less than today with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system. Open it, and it will scan your system. The junk files will be shown in the list.