Microsoft Office Forums - View Single Post - formula to work from data column

Thread: formula to work from data column

View Single Post

Old

08-08-2012, 07:20 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Okay, your original example had month and year numbers in separate cells. If you want to reference a single column which contains dates then a different formula is required. Here's one variation:

Code:

=AVERAGEIFS(SUPPORT!K9:K258,
    SUPPORT!J9:J258,">="&EOMONTH(TODAY(),-1)+1,
    SUPPORT!J9:J258,"<"&EOMONTH(TODAY(),0)+1)

Reply With Quote