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:05 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

You've referenced column J for both the Month and the Year criteria. What does column J contain?

Code:

=AVERAGEIFS(SUPPORT!K9:K258,SUPPORT!J9:J258,MONTH( TODAY()),SUPPORT!J9:J258,YEAR(TODAY()))

Reply With Quote