counting variables from two different columns

  • Thread starter Thread starter vince
  • Start date Start date
V

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.
 
-----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.
.
Click to expand...

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

Rekoj
 
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..
 
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).
 
Back
Top