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!D9

99,">="&DATE(2012,8,1),support!D9

99,"<="&DATE(2012,8,31))

And in case there might be no qualifying cells:

=IFERROR(AVERAGEIFS(support!K9:K99,support!K9:K99,">0",
support!D9

99,">="&DATE(2012,8,1),support!D9

99,"<="&DATE(2012,8,31)),0)

« Re: Date Format | Re: Date Format »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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 Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Column of formulas with some cells containing data derived from thereformula's I would like to find a formula to copy all cells with data (whichis actually text) from that column to another but leaving no blank cells inthis new column	barwald.simon@gmail.com	Microsoft Excel Discussion	2	10th Apr 2013 11:56 PM
Based on a condition in one column, search for a year in another column, and display data from another column in the same row >> look	MPSingley@midamerican.com	Microsoft Excel Misc	0	27th Dec 2006 05:31 PM
formula : =(column A)+(column B)-(column C). Why won't it work?	=?Utf-8?B?S3Jpc3RpbiBEcm92ZXI=?=	Microsoft Excel Misc	3	18th Oct 2006 08:48 PM
column to column conditional formatting won't work, need formula	=?Utf-8?B?cnJ1cHA=?=	Microsoft Excel Worksheet Functions	1	23rd Aug 2005 10:06 PM
what formula do i put for column m = column k minus column l in e.	=?Utf-8?B?amVubmlzcw==?=	Microsoft Excel Misc	5	6th Jan 2005 09:18 PM