Hi!

I'm assuming the Rowset range is A10:IV50

> correct

=COUNTIF(INDEX(Rowset,,COLUMN()),"0")

> good, thanks! two functions I'm not familiar with

So, whatever column the formula is entered in will be the column range
argument.

Example: if the formula is entered in A8 then the Countif range will be
A10:A50
If the formula is entered in E8 then the Countif range will be E10:E50.

Are you sure you want "0" ?

Excel treats all quoted values as TEXT.

> I'm not sure why I quoted it, I'd have thought it'd be treated as text also. It works that way (surprisingly), but also works without, so I'll not use them.

> Did you post your reply from Excelforum? If so, is there an easy way to reply to a message as one does with most email programs -- i.e. with the Subject: included and the original message quoted? (I didn't see anything about this on the Excelforum site.)

> Thanks again! -- Jim

Biff