Quote:
Originally Posted by 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, that only has the current month and year. ie Aug(8) & 2012
Regards
Rob
|
Hi Rob,
If you're using Excel 2007 or later then you can use AVERAGEIFS() rather than AVERAGEIF() so you can include more criteria.
On the proviso the cell containing "Aug 2012" is a date formatted cell and actually reads as say 01/08/2012 behind the scenes you can use that as the start criteria and EOMONTH() against the same cell for the end criteria.
Hope that makes sense. Let me know if not and I'll see what I can do about writing the formula for you. You'll need to let me know which column the dates are in and which column holds the "Aug 2012" value.
S.
Similar Threads
Threaded Mode
