Macro needed to average values on a per day basis, help please!!!

Attached is a sample excel sheet, the real one I'm working on is around 11800 rows long.

Hello,

I need a macro that will average the pH in column C by day. So in column A I have a " Date Time" format incrementing every 15 min ie. 11/23/11 10:00, 11/23/11 10:15. I want it to average it per day. So average the pH that are only during 11/23/11, then average the pH that are only during 11/24/11, then 11/25/11, and so on.

Any help would be appreciated! Thanks!!!Excel Help.xlsx

Can you use SumProduct:

=SUMPRODUCT(N(INT($A$2:$A$1000)=G2),$C$2:$C$1000)/SUMPRODUCT(N(INT($A$2:$A$1000)=G2))

given a date in G2?

I only have the dates available as a " Date time" format which in your case the code doesn't work, only with a date. It works but I would need to type out every date by itself.

How about this in D3 and copied down ( it will give the day's average at the start of each day):

Formula:

Please Login or Register  to view this content.

The int function will return the day of the timestamp, regardless of the time.