Your data problem may be a cell in column E which contains text instead of a
number.

Hope this helps,

Hutch

"Gary''s Student" wrote:

You do not have a formula problem. You probably have a data problem. For
example, if E25 thru G30 contain:

1 0 0
1 0 0
1 9 0
2 9 6.5
1 0 0
1 0 0

Your formula correctly returns 2
--
Gary''s Student - gsnu2007g


"Jason" wrote:

Can anybody tell me why they think this formula isn't working. I have
similar formulas in adjacent worksheets that work fine.

=SUMPRODUCT((E25:E5000)*(F25:F5000=9)*(G25:G5000=6 .5))

I get the #VALUE! error.