Results 1 to 10 of 10

Thread: COUNTIF With Multiple Criteria Across Multiple Columns

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 11-11-2013, 12:48 AM #1
    GymWrecker
    GymWrecker is offline
    Junior Member
    Join Date
    Apr 2013
    Posts
    8
    Rep Power
    0
    Well, I replaced "9" with the right criteria, but I'm now getting an error "N/A"

    This is the formula I have in
    F19=SUMPRODUCT(ISNUMBER(SEARCH("W7ZPB1",Master!$B$ 1:$B$300))*ISNUMBER(SEARCH({"*1A.*","*2A.*","*3A.* ","*4A.*","*5A.*","*6A.*","*7A.*"},Master!$K$1:$K$ 300))*ISNUMBER(SEARCH({"MG","BG","COL","LTC","MAJ" ,"CPT","1LT","2LT","CW4","CW3","CW2","WO1"},Master !$E$1:$E$300)))
    Last edited by GymWrecker; 11-11-2013 at 12:52 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sort Data By Multiple Columns And Delete Some Rows Based On Criteria
    By valesilver in forum Excel Help
    Replies: 6
    Last Post: 08-14-2013, 04:25 PM
  2. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  3. Sumif On Multiple Columns Using Multiple Criteria By Passing A Range Of Values
    By Luke M in forum Excel Help
    Replies: 7
    Last Post: 05-15-2013, 02:56 PM
  4. Match and CountIF Across Multiple Sheets Using Formula
    By khateeb in forum Excel Help
    Replies: 3
    Last Post: 03-12-2013, 12:54 PM
  5. Transpose Multiple columns data into multiple rows
    By manoj in forum Excel Help
    Replies: 2
    Last Post: 06-14-2012, 04:10 AM

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
  •  

Forum Rules