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, 06:50 AM

masterdineen masterdineen is offline

masterdineen is offline

masterdineen uses Windows XP

Windows XP masterdineen uses Office 2010 32bit

masterdineen uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Aug 2012

Posts: 11

masterdineen is on a distinguished road

Default

i am using the following equation

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

and i get #DIV/0!

Reply With Quote