Hi Biff,

Thank you very much for your time and assistance. That's worked Great!

Cheers,
Sam

T. Valko wrote:
Try this:

=SUMPRODUCT(--(MMULT((ISNUMBER(data))*(data=0),{1;1;1;1;1})=2))

That's based on your sample using 5 columns. For your real data with 8
columns change:

{1;1;1;1;1}

to:

{1;1;1;1;1;1;1;1}

Note this is limited to ~5400 rows of data.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200804/1