CuriousGeorg
09-24-2013, 12:26 AM
Morning,
a raw data file with lots of data input on different dates. On Sheet Combined column Q I have times ([h]:mm format).
What I need on my summary page is to be able to average the times based in Column P as long as they fall within the dates specified in cells (Summary G3 and H3).
I have tried
=AVERAGEIFS(Combined!Q:Q,Combined!G:G,"<="&H3,Combined!G:G,">"&G3)
However I get the answer as ##################
:think:
any help is great. (be even nicer if there was a vba code for it!)
a raw data file with lots of data input on different dates. On Sheet Combined column Q I have times ([h]:mm format).
What I need on my summary page is to be able to average the times based in Column P as long as they fall within the dates specified in cells (Summary G3 and H3).
I have tried
=AVERAGEIFS(Combined!Q:Q,Combined!G:G,"<="&H3,Combined!G:G,">"&G3)
However I get the answer as ##################
:think:
any help is great. (be even nicer if there was a vba code for it!)