Hi Pete,

In the Formula all range lengths are the same. This was a typo "I$5:I$42" in
the Sample Data
heading.

Cheers,
Sam

Pete_UK wrote:
The ranges should be the same length - try this:

=SUMPRODUCT(--(H5:H41="102/2"),--(I5:I410))

or make them both end at row 42 (your posting was ambiguous).

Hope this helps.

Pete

--
Message posted via http://www.officekb.com