formula to work from data column

M

masterdineen

Hello

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, tha
only has the current month and year. ie Aug(8) & 2012

Regards

Ro
 
J

joeu2004

masterdineen said:
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
Click to expand...

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

And in case there might be no qualifying cells:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

15 minute data to daily data 1
Getting the average from a column using date constrants 8
Count Dates in a range based on Column Header Id without using sum-product 1
Extracting data from database into separate sheets 0
Formula to fill cells based on Date of Arrival and Date of Departure 1
compare date range with date in columns and input data from another cell 2
calculate last 4 data points in a column (with sometimes blank rows) 7
NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET 3

Top