Previous Topic Next Topic

AverageIf function using dates

Closed
jpeg21 Posts 3 Registration date Tuesday 24 November 2015 Status Member Last seen 24 November 2015 - 24 Nov 2015 à 11:58
 RayH - 24 Nov 2015 à 19:02
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

Réponse 1 / 1
Blocked Profile
24 Nov 2015 à 17:07
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!
jpeg21 Posts 3 Registration date Tuesday 24 November 2015 Status Member Last seen 24 November 2015
24 Nov 2015 à 17:30
=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....
RayH > jpeg21 Posts 3 Registration date Tuesday 24 November 2015 Status Member Last seen 24 November 2015
24 Nov 2015 à 18:04
You were so close: 

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

Similar discussions

"Sorry, this feature isn't available ... " how to fix this?
Anonymous User -
heclam -

3 responses
How to disable Fn keys
HENRY -
ZiaRahman -

30 responses
fn key + space bar?
Zideh -
ellabella -

14 responses