Hi!

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.)

No, I access using Outlook Express. The Excelforum is just a "portal" that
links to these newsgroups.

Biff

"jmg092548" wrote
in message ...

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


--
jmg092548


------------------------------------------------------------------------
jmg092548's Profile:
http://www.excelforum.com/member.php...o&userid=26119
View this thread: http://www.excelforum.com/showthread...hreadid=394467