+ Reply to Thread
Results 1 to 2 of 2

Counting rows with specific criteria

  1. #1
    Registered User
    Join Date

    Smile Counting rows with specific criteria

    I want to count the number of rows if column A = "Shirts" and column C = "P". Can anyone help me with the code?

    Type Color Code Cost
    Shirts Blue P 15.00
    Shirts Red D 20.00
    Shirts Yellow P 15.00
    Shirts Black P 20.00
    Shirts White D 20.00
    Shirts Purple P 15.00
    Shirts Brown D 20.00
    Shirts Gray P 15.00
    Shirts Green P 20.00
    Shirts Orange D 20.00
    Shirts Violet P 15.00
    Shirts Beige D 20.00
    Shirts Pink P 15.00
    Shirts Olive P 20.00
    Shirts Tan D 20.00
    Skirts Blue P 15.00
    Skirts Red D 20.00
    Skirts Yellow P 15.00
    Skirts Black P 20.00
    Skirts White D 20.00
    Skirts Purple P 15.00
    Skirts Brown D 20.00
    Shorts Gray P 15.00
    Shorts Green P 20.00
    Shorts Orange D 20.00
    Shorts Violet P 15.00
    Shorts Beige D 20.00
    Shorts Pink P 15.00
    Shorts Olive P 20.00
    Shorts Tan D 20.00

  2. #2
    Forum Contributor
    Join Date
    Assuming your data is in Cols A through D, use the Array Formula (ctr+shift+Ent):

    In cell E1,

    Array enter and copy down Column E

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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