Count formula help

[kasmith1017]

Hi All,

There's probably an easy solution to this, but I am stumped because I've never had to think in this way so what I've come up with isn't calculating properly. When calculating commissions, my company has what is called pooled commissions. The way these work are as follows:
1. For each new client that signs on, we put $70 into a pool that is split amongst the team.
2. If an existing customer renews for a full year, we put $150 into a pool that is split amongst the team.

The second scenario is new. So previously I only had the first scenario and as a result created the first formula and it worked like a dream. However, customers only qualify as either a new signing eligible to have a pooled amount of $70, or a renewal that is eligible to get $150 for the pooled amount. I can't figure out a formula that would give me $290 total and not $360. Help!

 

[6StringJazzer]

We have to see what your data looks like to be able to give you a formula. How can you see when a new client signs on? How can you see if a customer renews?

 

[kasmith1017]

We have to see what your data looks like to be able to give you a formula. How can you see when a new client signs on? How can you see if a customer renews?

Yes, I accidentally hit "Ctrl Enter" and the post just went without a picture. I've edited now to add that in if you can refresh?

 

[kasmith1017]

I wanted to say that I figured this out by having two "COUNTIF" formulas in a single cell.