+ Reply to Thread
Results 1 to 3 of 3

Count if for multiple criterion

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    1

    Count if for multiple criterion

    Hi,

    I am working on a spreadsheet for a retail store. Column A has style numbers; Column B has an indication of A+ if that style number is a high selling item; Column C is called June and represents the number of units per style we will need in the month of June. There are some styles in June that we won't need at all and so the cell is blank for those style numbers in the June column.

    I want to count all style numbers we will be ordering in June that are also indicated as an A+ item in column B.

    So, I want to write a formula that says count populated cells in column C if column A has an A+.

    I am lost and so frustrated. Please help!

    Thanks,

    Michele

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Count if for multiple criterion

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Count if for multiple criterion

    Take a look at using the COUNTIF() function
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Row count using more than a single criterion?
    By TBrun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-22-2013, 09:08 AM
  2. Replies: 6
    Last Post: 10-17-2012, 07:32 PM
  3. Replies: 4
    Last Post: 04-24-2012, 11:01 AM
  4. [SOLVED] Sum Count of Numeric Criterion for LAST 5 Rows
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-18-2006, 01:35 PM
  5. [SOLVED] Sum Count of Numeric Criterion
    By Sam via OfficeKB.com in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-21-2005, 01:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1