Countifs and Averageifs

[jsteifel]

I am currently using the following formula to count the number of sold units in the last 30 days that matches this criteria.

=ARRAYFORMULA(COUNTIFS(Sold!C:C,"C300W4", Sold!I:I, "MB CERT", Sold!B:B,"2011", Sold!D:D, I7, Sold!AG:AG,">" &TODAY()-30))

Using the same criteria, I would like to get the average of Sold!AK:AK for those that match the criteria in the above formula. How would I do that?

 

[Aladin Akyurek]

This looks like Google Sheets. Are you sure this needs to be an arry formula for:

=COUNTIFS(
   Sold!C:C,"C300W4",
   Sold!I:I,"MB CERT",
   Sold!B:B,"2011",
   Sold!D:D,I7,
   Sold!AG:AG,">"&TODAY()-30)

And for avearging...

=AVERAGEIFS(
  Sold!AK:AK,
  Sold!C:C,"C300W4", 
  Sold!I:I,"MB CERT",
  Sold!B:B,"2011",
  Sold!D:D, I7,
  Sold!AG:AG,">"&TODAY()-30)