Average of numbers between dates range in a table!
Hello everyone,
Trying to get the average of number's count in a table column, based on the dates range in the second column!
Having a look at the sheet attached will better explain the issue I guess
I have attached an example, I wish someone can help.
Thanks.
Last edited by BassemCh; 01-14-2022 at 04:39 PM.
try
=AVERAGEIFS(A3:A24,B3:B24,">="&E4,B3:B24,"<="&E5)
are you still using excel version 2010
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks