Hi Everyone,

I have a table of data and need a COUNT of the NEXT Row when various
criteria is met for the Row above. I'm using the SUMPRODUCT criteria to
find the Rows that actually match the criteria, but I need the Count to
reflect the Row directly below matched criteria.

Eg: =SUMPRODUCT(--($A$1:$A$500=H4),--($B$1:$B$500=I4))

So, if data on Row 12 meets the above SUMPRODUCT Criteria, I would like the
count to reflect the count of data on Row 13, Not Row 12.

ROW 12 matches criteria - Count data for ROW 13
ROW 20 matches criteria - Count data for ROW 21
ROW 40 matches criteria - Count data for ROW 41 etc.,

Help very much appreciated.

Regards,
Sam

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