T
Tony
Hey guys,
Here is a question for anyone who may be able to shed light on this.
Is there a way to count specifically on certain values, but
incorporating a wildcard at the same time? Here is an example:
Agent Code
1234 1R
3467 2B
3453 1B
5766 6G
1233 1A
What I want to do is be able to count how many agents used a code
starting with a one. I know I can use
=(abs(sum
Here is a question for anyone who may be able to shed light on this.
Is there a way to count specifically on certain values, but
incorporating a wildcard at the same time? Here is an example:
Agent Code
1234 1R
3467 2B
3453 1B
5766 6G
1233 1A
What I want to do is be able to count how many agents used a code
starting with a one. I know I can use
=(abs(sum
Code:
="1R"))+(abs(sum[code]="1B")) and so on and so on. Is
there way to incorporate a wildcard into that statement so I don't
have to code this super long statement? Thanks in advance