Sorry for the confusion. Here's what I'm trying to do.
Col 1 Col 2 Col 3
x N
x E
x S
x W
x S
x E
x N
x N
x N
x E


N 0 0
E
S
W


--
Thank you for you help
MO
Albany, NY


"Richard Buttrey" wrote:

On Fri, 10 Mar 2006 06:41:29 -0800, MO
wrote:

Thank you for your help Duke. Your assumptions are correct; however, it does
not work. I need a count of how many x's are in column A for each(N E S W)
and I need a count of how many x's are in column B for the same. I know I
have to list N E S W somehwhere and then I need a count for x's for each to
appear.

Could you post some typical data in the layout you have, and indicate
what you expect to see as a result. That would enable us to better
understand your requirement.

Rgds



Richard Buttrey
__