Hi all
Is there a way various formulas (AVERAGEIF, SUMIF, COUNTIF etc) can be used so that they only include the last 10 times the one of the criteria's is found?
For example
The main criteria to use is APPLES
=COUNTIFS(A:A,"APPLES",B:B,"YES")
Apples could appear 30 times in column A but I only want column B to count "YES" first 10 times that "APPLES" appear in column A. The newest data will always at the top of column A.
Thanks
Is there a way various formulas (AVERAGEIF, SUMIF, COUNTIF etc) can be used so that they only include the last 10 times the one of the criteria's is found?
For example
The main criteria to use is APPLES
=COUNTIFS(A:A,"APPLES",B:B,"YES")
Apples could appear 30 times in column A but I only want column B to count "YES" first 10 times that "APPLES" appear in column A. The newest data will always at the top of column A.
Thanks