Hello,
I'm looking to calculate the average A2 to lastRow for every 30 minutes (30 Rows) only if the status says: Good in Column C and the first range to start with has to be 00mins. for example to start the first 30 rows average at 9:00.
The values that need to be averaged are in column B.
I'm not sure what my best route. VBA seems to be complicated using averageif formulas. I attempted to calculate average for each 30 rows but i had to manually specify the last column. Also, I was able to do some calculations to figure out where to start 00mins sharp but how to include it in the formula.
I'm looking to calculate 30mis average and 24 averages
I would really appreciate any input /help I can get.
Thank you
View attachment Book1.xlsx
I'm looking to calculate the average A2 to lastRow for every 30 minutes (30 Rows) only if the status says: Good in Column C and the first range to start with has to be 00mins. for example to start the first 30 rows average at 9:00.
The values that need to be averaged are in column B.
I'm not sure what my best route. VBA seems to be complicated using averageif formulas. I attempted to calculate average for each 30 rows but i had to manually specify the last column. Also, I was able to do some calculations to figure out where to start 00mins sharp but how to include it in the formula.
I'm looking to calculate 30mis average and 24 averages
I would really appreciate any input /help I can get.
Thank you
View attachment Book1.xlsx