Why sumproduct formula return result 0

Originally Posted by ARIA1

Do i need every time to correct the formula >!

Hello ARIA1, I'm not sure what you mean by that comment, if you use the formula that Marcol suggests then it should work...then you can use that formula every time.

In Excel 2007 you might prefer to use SUMIFS, i.e.

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