Excel 2003 - Average of data entered in last 28 days

grip88

New Member
Joined
Mar 28, 2012
Messages
14
I'm having a few issues calculating an average that includes a changing dataset.
Column A: Date data in entered
Column H: The data i want to find the average of
Cell L1 - Where I need the result.

The number of data rows changes every day but the dates the data relate to aren't always entered in the correct date order. How do i calculate the average of the data for the past 28 days only.

Any help would be much appreciated.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

davesweep

Well-known Member
Joined
Apr 30, 2007
Messages
510
Hi,

You could use an array formula like this:

=AVERAGE(IF(A:A>TODAY()-28,H:H,""))

confirm with CTRL, SHIFT, and ENTER
 

Watch MrExcel Video

Forum statistics

Threads
1,100,214
Messages
5,473,202
Members
406,851
Latest member
Debbren

This Week's Hot Topics

Top