Having issues counting unique instances of pick up and drop off locations based on if money is in the same row.

I have a contract I'm working on for work so I will give what I can to see if someone can help. We have roughly 62k rows of information. It is a combination of pickup and dropoff locations. There are 9 pickup locations with various dropoff locations. Each pickup and dropoff are repeated 3 times based on another column. What I am looking to do is on a summary tab I want it to reference the origin location go to the full data sheet and count each row that has that origin with money and count only the first time the pickup and drop off location appears. I'm not sure if this is possible or if I just need to manually counting. For reference I've tried a combination of ROW, UNIQUE, and FILTER with various COUNTIFS or IF statements but nothing has worked. Even resorted to asking AI but either my prompts aren't correct or it just doesn't understand. Thanks in advance for any advice or tips to try!