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?
=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?