Prev: Possible to have various sections of worksheets print on 1 page?
Next: Formula Help
From: FunChickyPoo on 28 Apr 2010 14:10
I have been using the following SUMIFS funtion that works perfectly, but need
to average a column of %. Is ther esucha thing as AVERAGEIFS that will work
with multiple criteria?

=SUMIFS(AF$4:AF$169,$G$4:$G$169,$G174,$F$4:$F$169,$F174,$J$4:$J$169,"<=12/31/10",$J$4:$J$169,">=01/01/10")
From: T. Valko on 28 Apr 2010 14:15
SUMIFS and AVERAGEIFS use the same syntax so all you need to do is replace
SUMIFS with AVERAGIFS.

--
Biff
Microsoft Excel MVP


"FunChickyPoo" <FunChickyPoo(a)discussions.microsoft.com> wrote in message
news:4D8F823D-834A-411C-A51B-FF5C6CE02DB5(a)microsoft.com...
>I have used the following formula and it works perfectly, however, one
>column
> is % and I want to get an average of the %'s with the same criteria. Can
> this be done?
>
> Basically, is there and AVERAGEIFS function?
>
> =SUMIFS(AT$4:AT$169,$G$4:$G$169,$G174,$F$4:$F$169,$F174,$J$4:$J$169,"<=12/31/10",$J$4:$J$169,">=01/01/10")


From: PJFry on 28 Apr 2010 18:35
AVERAGEIFS should work. You may want to format your dates differently.
Instead of "<=12/31/2009", try "<="&DATE(2009,12,31).
--
Regards,

PJ
Please rate this post using the vote buttons if it was helpful.



"FunChickyPoo" wrote:

> I have been using the following SUMIFS funtion that works perfectly, but need
> to average a column of %. Is ther esucha thing as AVERAGEIFS that will work
> with multiple criteria?
>
> =SUMIFS(AF$4:AF$169,$G$4:$G$169,$G174,$F$4:$F$169,$F174,$J$4:$J$169,"<=12/31/10",$J$4:$J$169,">=01/01/10")
 | 
Pages: 1
Prev: Possible to have various sections of worksheets print on 1 page?
Next: Formula Help