LinkBack URL
About LinkBacks
I have a list of data where the date is in column A and values are in E. I need to take only that numbers that were recorded on a Monday and average them.
Thanks
I have a list of data where the date is in column A and values are in E. I need to take only that numbers that were recorded on a Monday and average them.
Thanks
Last edited by TheNameless122; 07-14-2010 at 08:58 AM.
=AVERAGE(IF(WEEKDAY(A2:A20,2)=1,E2:E20))
array entered (using Ctrl+Shift+Enter) and adjust ranges to suit.
Everyone who confuses correlation and causation ends up dead.
Very helpful, Im going to work on this for a while, but im sure I will need more help soon. Thanks.
How could you do...
put contents from cell E2 in current cell if it was recorded on a Monday?
=if(weekday(a2,2)=1,e2,"")
Great, last thing... How can you average the contents of a column while excluding the value of zero.Originally Posted by romperstomper
Much like the date:
=AVERAGE(IF(E2:E20<>0,E2:E20))
array-entered.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks