formula that counts numbers starting with x in one column + word in another column

Hi,

Example:

Column A = Traffic Type
Free
Paid
Direct
Referral

Column B = Phone IVR number sequence
0
0
1
11
2
2
21
22
231
33
3
9

I need to create a formula that takes into account multiple criteria (A,B). I need to count a phone IVR number starting with say number "2" (column B) and I need to check how many calls where that number was selected came from the different traffic types in this example "free" (column A). So then I can re-use the same formula for each IVR number and just change the "traffic type" word from column A.

I am already using a sumproduct formula to only count the numbers in Column B for "startswith" and it works fine. Formula: =SUMPRODUCT(--(LEFT(AC2:AC6909,1)="1"))

Appreciate any assistance.

Thanks
Matt

Hi shukla

thanks for your response. I will try Tony's recommendation and if no luck with provide a sample file.

Thanks
Matt

Hi Tony,

Thanks! for the recommendation. I will try this and let you know how I go.