counting variables from two different columns

[vince]

I have a spread sheet containing one column listing a
particular village and another indicating a cohoice of
memberships. I want to count the number of villages that
has a particular membership in the corresponding row.

 

[Rekoj]

-----Original Message-----
I have a spread sheet containing one column listing a
particular village and another indicating a cohoice of
memberships. I want to count the number of villages that
has a particular membership in the corresponding row.
.

It would be best to use the Countif function. You will
want to reference help for its syntax.

Rekoj

 

[Peo Sjoblom]

And? Replace the A1:100 with the Village range and the B1:B100 with the
Membership range, then replace D1 with a cell where you type Acme and
E1 with a cell where you type Sports..

 

[Myrna Larson]

A Pivot Table will give you the counts for all villages and memberships at once.

Use the Village as a row field, membership as a column field AND as a data field, with the
arithmetic function being Count (probably will already be selected since the data is text).