Why sumproduct formula return result 0

Originally Posted by ARIA1

HI..IM NEW IN THIS FORUM AND IN EXCEL GENERALY

I have a little problem with sumproduct formula in excel 2007...
=SUMPRODUCT(F4:F35=B82,G4:G35=F98,J4:J35) and i get the 0 result

but when i put manualy this formula i get the proper result
=SUMPRODUCT((F4:F35=B82)*(G4:G35=F98)*(J4:J35))

my colums are TEXT ---TEXT---NUMBER

so is there a way not to do this manualy ?!

THNX

Since you're using Excel 2007 you can use the SUMIFS function...

=SUMIFS(J4:J35,F4:F35,B82,G4:G35,F98)