SumProduct Formula Giving Zero Value

[mazher]

Hi All,

I am using this formula

=SUMPRODUCT(--(C2:C18396=Q3)*--(H2:H18396=R2)*((N2:N18396)))

in cell R2 but is giving zero

I have also tried using

=SUMPRODUCT(--(C2:C18396=Q3),--(H2:H18396="CASH"),--(N2:N18396))

but the same result

if some guru can tell me, where i am wrong.

Thnaks in advance.

Regards

Mazher

 

[VoG]

In a spare column

=INT(C2)

and copy down. Then use that column in the SUMPRODUCT.

 

[VoG]

Or maybe

=SUMPRODUCT(--(INT(C2:C18396)=Q3),--(H2:H18396="CASH"),N2:N18396)