On Fri, 10 Mar 2006 07:33:00 -0800, MO
wrote:

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

Thanks,

With the data above in A10:C10, enter N, E, S, W into E1:E4

Then put
=SUMPRODUCT((A$1:A$10="x")*($C$1:$C$10=$E1))
into F1 and copy to F1:G4

HTH

Richard Buttrey
__