Counting strings

[gtsolid]

Hi!
In the attached file i'm trying to count cells in which a string appears.
the problem is the quantity: if in A5 i set 2, it means I'd like to count twice the products in raw C5:E5

is it possible to solve this problem with a SUMPRODUCT?
The correct result in G1 is 3

[AliGW]

Administrative Note:

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this. Thanks.

[Pepe Le Mokko]

Like this ?

Please Login or Register  to view this content.

[bsalv]

Please Login or Register  to view this content.

[gtsolid]

Why

Please Login or Register  to view this content.

is not working? Usually i use more than 1 array with SUMPRODUCT

Please check that your forum profile is up-to-date in this respect.

I updated, thanks for the reminder

[DJunqueira]

You were trying to multiply before converting true/false to 1/0, try the formula below.

Please Login or Register  to view this content.

[gtsolid]

Understood. What about if I have a table, for example

Please Login or Register  to view this content.

[Pepe Le Mokko]

You don't seem to have taken a moment to read my solution in post #3 ? The order of arrays is important but there is no need for double anarry

[gtsolid]

You don't seem to have taken a moment to read my solution in post #3 ?

It works fine thanks, but i'd like to understand how to use table, not only arrays

[Pepe Le Mokko]

Just make a Table from your existing range , then build the formula as usual by selecting the ranges you need. XL will automatically add the structured references