Ask a Question
or
Create a Poll
  1. Home /
  2. Questions /
  3. Computers
  4. / Computer Software
  5. / Spreadsheet Software

by Boscos on April 19th, 2007

Boscos

Question

Help answer this question below.

Microsoft Excel 2000 - I am trying to obtain how to count the number of rows that correspond to a variety of column criteria (e.g. column A is equal to to "N" and column B is equal to "Y") and counting for a number of rows (total rows with this criteria)

  • Like
  • Report
Share:
Other

Answers. 4 helpful answers below.

  • by Cyanotic Wasp on October 7th, 2008

    Cyanotic Wasp

    I like firecircle's Array formula, but those things can be very tricky until you master them. I'm still working on that, myself.

    I find the SUMPRODUCT() function to be a lot simpler to understand and troubleshoot later:

    =SUMPRODUCT(( A1:A100 = "N") * ( B1:B100 = "Y"))

    enter this as a normal function, with Enter key only. This will return the number of rows that have both "N" and "Y" values in their respective columns.

    No comments. Post one | Permalink

  • by firecircle on October 5th, 2008

    firecircle

    To count the number of times col A="N" and col B="Y":
    =SUM(IF( A1:A100="N", IF(B1:B100="Y",1, 0),0))

    This is an array formula, so instead of just pressing ENTER, press CTRL+SHIFT+ENTER at the same time. Excel will enclose the formula in {curly brackets} to indicate it is an array formula.

    No comments. Post one | Permalink

  • by Brian I on April 19th, 2007

    Brian I

    I'm not clear exactly what you are trying to do, but if you add a comment here you'll have more space to explain. Sounds as though you need to look at the Countif function though.

    No comments. Post one | Permalink

  • by fataka on April 19th, 2007

    fataka

    OR Perish

    No comments. Post one | Permalink

Want to attach an image to your answer? Click here.

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

You're reading Microsoft Excel 2000 - I am trying to obtain how to count the number of rows that correspond to a variety of column criteria (e.g. column A is equal to to "N" and column B is equal to "Y") and counting for a number of rows (total rows with this criteria)

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Count in excel 2000
Excel 2000 count function
Count excel deutsch
Countif excel deutsch
Excel 2000 count rows

Answerbag

a Demand Media company