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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deleting numbers in a column 2
Counting multiple memberships 1
Word to Excel: Export comments with text and line number 0
Word Create a Phone Book using MailMerge in word 2007 0
Idetnifying repeats in a column 1
Match and delete rows on two different sheets from reference numbers 4
IF Statement Help 4
SUM with two conditions 4

Back
Top