Re: formula to work from data column

joeu2004
Guest
Posts: n/a

 8th Aug 2012
"masterdineen" <(E-Mail Removed)> wrote:
> I have the following equation =AVERAGEIF(SUPPORT!K9:K99, ">0")
> support!K9:K99 being number of daydiff.
> I want to select the daydiff values based on another date column,
> that only has the current month and year. ie Aug(8) & 2012

=AVERAGEIFS(support!K9:K99,support!K9:K99,">0",
support!D999,">="&DATE(2012,8,1),support!D999,"<="&DATE(2012,8,31))

And in case there might be no qualifying cells:

=IFERROR(AVERAGEIFS(support!K9:K99,support!K9:K99,">0",
support!D999,">="&DATE(2012,8,1),support!D999,"<="&DATE(2012,8,31)),0)

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post barwald.simon@gmail.com Microsoft Excel Discussion 2 10th Apr 2013 11:56 PM MPSingley@midamerican.com Microsoft Excel Misc 0 27th Dec 2006 05:31 PM =?Utf-8?B?S3Jpc3RpbiBEcm92ZXI=?= Microsoft Excel Misc 3 18th Oct 2006 08:48 PM =?Utf-8?B?cnJ1cHA=?= Microsoft Excel Worksheet Functions 1 23rd Aug 2005 10:06 PM =?Utf-8?B?amVubmlzcw==?= Microsoft Excel Misc 5 6th Jan 2005 09:18 PM

Features