membership list

Hi

One way, assuming your category to be in column E and *** in column F
=SUMPRODUCT(--($F$2:$F$1000="F"),--($E$2:$E$1000="A"))
change ranges to suit.

Regards

Roger Govier


cruncher wrote:
> Well, we took the suggestions and put them to work. We're impressed. Sorted
> and printed wonderfully. Saves a lot of hard work.
>
> Appreciate the help.
>
> Something else popped up during the evening which we didn't think of when
> posing the first question.
>
> The database with the several categories of skill levels contains male and
> female of course! Column F contains the letter M or F to designate that. How
> would a person build a formula that would combine the data from that column
> as well as the information of the category in the other column?
>
> IOW, the Excel has to search for two criteria. Any attempts of mine to build
> such a formula just upset the computer. :-)
>
>
>
> "cruncher" <wuss@unreal.net> wrote in message
> news:11jajreaovilk90@corp.supernews.com...
>
>>Friend of mine manages the membership list for a club, about 500 or so,
>>using Excel as the program.
>>
>>It contains the usual; names, addresses, phone numbers, skill levels.
>>Presently there are five levels.
>>
>>As can be expected, the list constantly changes with members moving to
>>different levels, coming or leaving the club. There has to be periodic
>>reports to the executive of the numbers in each category.
>>
>>I suggested adding a couple of blank lines after each category and using
>>the CountA function to count the number of members in each category but
>>I'm not very good at Excel either.
>>
>>The category beside each member is identified by A for advanced, I1, I2,
>>I3 for intermediate levels and beg for beginner level.
>>
>>Can the formula be adapted to count the number of "a" etc. in the list?
>>
>>Another cell could be used to count the total membership.
>>
>>How would other users approach the task?
>>
>>Thanks
>>
>
>
>

"Roger Govier" <roger@nospamtechnology4u.co.uk> wrote in message
news:4337B2D6.4010309@nospamtechnology4u.co.uk...
> Hi
>
> One way, assuming your category to be in column E and *** in column F
> =SUMPRODUCT(--($F$2:$F$1000="F"),--($E$2:$E$1000="A"))
> change ranges to suit.
>
> Regards
>
> Roger Govier

I believe you have the correct columns. I don't have the database here. I'm
only assisting and don't own it.

I will pass this on tonight and if we have time, test it. We should be able
to modify the formula if required.

Thanks

<snip>