AverageIf function using dates

Closed
jpeg21 Posts 3 Registration date Tuesday November 24, 2015 Status Member Last seen November 24, 2015 - Nov 24, 2015 at 11:58 AM
 RayH - Nov 24, 2015 at 07:02 PM
Hi there. I'm trying to set up an average function based on dates entered in column a, for the data in column b.

I want to use the data in b if the date in a is past already "<today()"
Related:

1 response

Blocked Profile
Nov 24, 2015 at 05:07 PM
OK, so where are you stuck? Post your code so that we can help with you where you are stuck, and not reworking the project you have already started!
0
jpeg21 Posts 3 Registration date Tuesday November 24, 2015 Status Member Last seen November 24, 2015
Nov 24, 2015 at 05:30 PM
=averageif(C79:C99,<today(),D79:D99)

C79:C99 has dates (2015-06-33, 2015-07-31, 2015-08-31....)
D79:D99 has $ value.

I want to get the average value of everything associated to a date <today()

let me know if my request is not accurate enough....
0
RayH > jpeg21 Posts 3 Registration date Tuesday November 24, 2015 Status Member Last seen November 24, 2015
Nov 24, 2015 at 06:04 PM
You were so close:

=averageif(C79:C99,"<" & today(),D79:D99) 
0
jpeg21 Posts 3 Registration date Tuesday November 24, 2015 Status Member Last seen November 24, 2015
Nov 24, 2015 at 06:11 PM
not sure if your line is the answer but it doesn't work...
0
RayH > jpeg21 Posts 3 Registration date Tuesday November 24, 2015 Status Member Last seen November 24, 2015
Nov 24, 2015 at 07:02 PM
works on mine.
What is happening on your sheet?
More details please.
Give more examples.
Post your sheet.
0