I have Excel columns with different statements (yes, no; numbers).
 

I keep membership records on Excel. Some of the columns include things like
"Yes" and "No". Others are codes (e.g. for ethnicity - 1 to 9). I need to
produce statisitics every quarter, analysing these columns. I can do this by
hand but is there a way of doing this in Excel. E.G. for ethnicity "1" has 4
records; "2" has 1 record etc.

David

have a look at the Help for COUNTIF, SUMIF and, if you're looking for
combinations, SUMPRODUCT. For example, check column A for "yes" and sum
column B if it is.

=SUMIF(A:A,"yes",B:B)

Regards

Trevor


"David Verlander" <David wrote in
message ...
I keep membership records on Excel. Some of the columns include things
like
"Yes" and "No". Others are codes (e.g. for ethnicity - 1 to 9). I need
to
produce statisitics every quarter, analysing these columns. I can do this
by
hand but is there a way of doing this in Excel. E.G. for ethnicity "1"
has 4
records; "2" has 1 record etc.

David

Check out Excel's Help on "Frequency" Function. There is an example.

Remember this is an Array Function and must be entered using CRTL + SHIFT +
ENTER

Gord Dibben Excel MVP

On Fri, 26 Nov 2004 11:39:02 -0800, David Verlander <David
wrote:

I keep membership records on Excel. Some of the columns include things like
"Yes" and "No". Others are codes (e.g. for ethnicity - 1 to 9). I need to
produce statisitics every quarter, analysing these columns. I can do this by
hand but is there a way of doing this in Excel. E.G. for ethnicity "1" has 4
records; "2" has 1 record etc.