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
Sample-Sheet.xlsm
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for your thoughts and testing.
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