Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    How count cell contents based on multiple criteria (Excel 2002)

    I have a worksheet with the month and year (as text) in column A and "Yes" and "No" text in column F. I want to have excel count the number of "Yes" values for a given month-year and return that value in a cell. I can effectively do this manually by autofiltering the data to the month-year I want and then filtering the "Yes" cells in column F and then counting them, but I would like to do this in a formula automatically in a cell. Can anyone show me how to do this.

    Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: How count cell contents based on multiple criteria (Excel 2002)

    Hi Larry,

    Welcome to Woody's Lounge!

    Say that the month-year you want to count the Yes-es for is in cell H1. The following formula will return the count:<pre>=SUM((A1:A100=H1)*(F1:F100="yes"))</pre>

    This is an array formula, i.e. it must be confirmed with Ctrl+Shift+Enter instead of the customary Enter.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •