Sumproduct formula

[sachar]

Dear All,

With the help of “Sumproduct” formula to get the total number of “Club Car” in column “E” the no value return “#Value” (E24) (sample file attached). May I know the mistake?

Can we apply the” count if” formula also?

 

[Ramesh]

Yes. You can count those values by using a wild card character in your CountIF formulas criteria as follows :

Here is the formula :

=COUNTIF($E$2:$E$39,CONCATENATE(E41,"*"))

Hope that helps!!

 

[jayalaxmi]

Dear All,

With the help of “Sumproduct” formula to get the total number of “Club Car” in column “E” the no value return “#Value” (E24) (sample file attached). May I know the mistake?

Can we apply the” count if” formula also?

do u need the count of club car/
CLUB CAR CARRYALL/
CLUB CAR PRECEDENT
,

 

[Tiago MF]

To use sumproduct there, change your formula to:
=SUMPRODUCT((LEFT(E2:E39,4)=E41)*1)

Best,

 

[Deepak]

Yes. You can count those values by using a wild card character in your CountIF formulas criteria as follows :

Here is the formula :

=COUNTIF($E$2:$E$39,CONCATENATE(E41,"*"))

Hope that helps!!

This will do the same job

=COUNTIF($E$2:$E$39,E41&"*")

 

[Deepak]

To use sumproduct there, change your formula to:
=SUMPRODUCT((LEFT(E2:E39,4)=E41)*1)

Best,

This would be more versatile.

=SUMPRODUCT(--ISNUMBER(FIND(E41,$E$2:$E$39)))

 

[sachar]

Dear All,

Now i got it, thanks to all.