Forum Discussion
[Excel Formula?] How to calculate a product's sales rank based on 3 criteria
Hi, is there a formula that can calculate a Product's Sales Rank in year 20xx (starting with 1 as the 'highest' rank in the year 20xx) that corresponds with the Product Name AND the Sales Year. The e...
Is this what you want?
The formula in D2 is
=IF(--RIGHT(D$1, 4)=$A2, COUNTIFS($A$2:$A$9, $A2, $C$2:$C$9, ">="&$C2), "")