Hi Guys,

I am currently using an IF Count Function on to sort out the statement below.

So as you can see there is different types of transaction.I am using IF COUNTIF here and drag it for each line to sort out the amount i want in Phone (Virgin Media here is a phone provider and the formula is to categorize them as such) “Virgin” being the keyword for my selection.

Now let’s say i have different suppliers. In the case below, i am adding Starlink Telecom and  the formula will work as follow.

 The problem i have with this is the fact that i manually have to add every phone provider in my formula.

What i am trying to do instead is link the two phones suppliers here to list i would have made in another worksheet. The formula will then just read into the column C, pick the names and add the amount in the original sheet once there is a translation that contain those keyworlds.

Anyone has an idea on how to achieve that?

Thanks for taking the time to read this.

​Hi Guys,I am currently using an IF Count Function on to sort out the statement below.So as you can see there is different types of transaction.I am using IF COUNTIF here and drag it for each line to sort out the amount i want in Phone (Virgin Media here is a phone provider and the formula is to categorize them as such) “Virgin” being the keyword for my selection. Now let’s say i have different suppliers. In the case below, i am adding Starlink Telecom and  the formula will work as follow.  The problem i have with this is the fact that i manually have to add every phone provider in my formula. What i am trying to do instead is link the two phones suppliers here to list i would have made in another worksheet. The formula will then just read into the column C, pick the names and add the amount in the original sheet once there is a translation that contain those keyworlds.  Anyone has an idea on how to achieve that?  Thanks for taking the time to read this.     Read More

​