Hi all,
Example: I have dates from A1 to A31 (1st May to 31st May). I have number values from B1 to B31.
Now I would like to calculate i.e. average in C1 in a way it takes cells in B column from B1 to cell what is in a same row than TODAY. Today is 9th of May so I would like it will automatically calculates in C1 AVERAGE(B1:B7) tomorow AVERAGE(B1:B8) ...
Thank you for help!
=average(b1:index(b1:b31,match(today(),a1:a31,0)))
Josie
if at first you don't succeed try doing it the way your wife told you to
Welcome to the forum
you can try it like this
=AVERAGE(IF(A1:A31<=TODAY(),B1:B3)) - ctrl + shift + enter not just enter
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks