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
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()"
I want to use the data in b if the date in a is past already "<today()"
Related:
- AverageIf function using dates
- Accessor function c++ - Guide
- Find function on mac - Guide
- Spreadsheet function - Guide
- Network card function - Guide
- Hard drive function - Guide
Nov 24, 2015 at 05:30 PM
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....
Nov 24, 2015 at 06:04 PM
Nov 24, 2015 at 06:11 PM
Nov 24, 2015 at 07:02 PM
What is happening on your sheet?
More details please.
Give more examples.
Post your sheet.