Average Question, based on 2 to 3 sets of criteria.

ExcelDude

New Member
Joined
Sep 14, 2006
Messages
8
OK, I have a promotion begin date, and a promotion end date in 2 columns. I also have, say 50 columns with weekly sales data and a date heading. What I need to do is to average this data in 3 different areas. Avg before promo, during promo, and after promo. I also need it to average data that does not have a zero, which I believe I know how to do(=AVERAGE(IF(A2:A7<>0, A2:A7,""). Right now I'm manually averaging this data based on the different beg. and end dates, but it's a very manual process as the beg. and end dates very from title to title. Any ideas?
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
Can't you use a similar Average(if formula and make the criteria <= cell with reference begin date, etc..?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,918
Messages
5,545,025
Members
410,647
Latest member
bernardazar
Top