Alternative to this function SUMPRODUCT

[bines53]

Hello Friend !

Is there a good alternative to the function SUMPRODUCT ,Without using Ctrl+Shift+Enter.

Thank you !

 

[Somendra Misra]

Hi David,

You can use MMULT function and in this case without use CSE like

in I2:

=MMULT(--(B2:F2-A2:E2=1),{1;1;1;1;1})

in J2:
=MMULT(--COUNTIF(A2:F2,A3:F3),{1;1;1;1;1;1})

Regards,

 

[bines53]

Hi Somendra,

in L2:=MMULT(--ISODD(--A2:F2),{1;1;1;1;1;1})
As you have given in my previous thread .
Just missing me: k2

Thank you !

 

[Somendra Misra]

@bines53

Just missing me: k2

Not getting you?

Regards,

 

[bines53]

Hi Somendra,

I did not understand your last comment.

Regards,

 

[bines53]

Hi Somendra,

in K2:=MMULT(--(A2:F2-A3:F3>0),{1;1;1;1;1;1})

Thank you !