Ask ko lang kung pano kaya magiging count as 1 ito?

alin jan ang ikacount as 1?

yan lahat po. dapat si aidas ay count as 1 tapos sales nya ay 4k

Create a unique syntax like combined Name and Sales Rep Name.

for me gagamit q ng helper column na mag iidentify ng unique then saka aq mag peperform ng sumifs base sa unique value sa helper column

kaso need pa isort yung amount from highest to lowest para mag work

Jeysel Pablo Exactly What You want.... Show expected result

Try =sumproduct(1/(countif(range)