AverageIFS() Not Working

I have a sample file I am attaching where for the life of me I can not figure out why the AverageIfs() Statement is not working, I would appreciate any help I can get.  Also, I am starting to get concerned about the speed in which my macro is working.  This is sample data the real data involves 1,000 of automobiles and years of data.  Any suggestions on how I might be more efficient would be nice as well.
Sample-Sheet.xlsm
kscott61Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
When i run the macro i don't ran into any issues on the same and it runs quickly for me without any challenges..

Also from an ideal solution stand point of view if i have been in your place i will make a pivot table as shown in sheet-2 as this is much faster and easier to play then your macro or data set..

Saurabh...
Sample-Sheet.xlsm
kscott61Author Commented:
Saurabh,

Thank you I understand and have utilized Pivot tables a great deal.  But this is only a sample of what I am doing with the data, and although I could do what I want with multiple tables I think the macro is still my best path.

Good News, is the pivot table you provided helped me see that my AverageIfs was actually working and what I really wanted was to take the total number of miles summed each month by the number of months with data to get a monthly average.  What I am getting is an average for every report turned in.  So I am good this this part.

My other hope was that someone would tell me a better way of doing the formulas verses in a loop record by record.  The actual data file I will be ultimately using has over 600K rows.  So going record by record is going to take a very long time.
Saurabh Singh TeotiaCommented:
I will say if you have that many number of data records..Then going by each record is faster then applying the formula in all the cells at 1 go and i'm sharing it with my personal experience..

Here is why its more faster because when you apply a formula on one cell at a time you are not pushing your computer neither excel to its limit of computation powers and as a result it calculates faster for a cell and then move on and so on..Again if you have a huge dataset and apply formula in that in 1 go the computation and calculation will take time which will increase the overall run time of your macro..

To share some results that i did on testing on this earlier when i applied formula in lets say 100k rows a complex one in 1 go..it took 8-10 hours to complete the entire processing..where when i changed this to cell by cell same got reduced by 1/4 and the entire work got done in 2-3 hours...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kscott61Author Commented:
Thank you for your thoughts and testing.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.