SUBTOTAL instead of AGGREGATE. but not worked.
i used this Function <pre>=IF($G55 <> "",AGGREGATE(14,4,($G$2:$G$51=$G55)*$F$2:$F$51,1), "")
Aggregate
Subtotal
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)