+ Reply to Thread
Results 1 to 2 of 2

CountIf multiple cells

Hybrid View

  1. #1
    Registered User
    Join Date
    04-04-2015
    Location
    Vancouver, Canada
    MS-Off Ver
    Office 365
    Posts
    88

    CountIf multiple cells

    Hi,
    How do I use countif (or if you have a better suggestion please tell me) to count if:
    cell1 = "a"
    cell2 = ""
    cell3 = ""
    cell4 = "1"

    I tried it out myself but I keep getting incorrect answers.. I used vba 2d array:
    string = cell1 & "(" & cell2 & cell3 & cell4 & ")"
    if string = "a(1)" then column next to = +1

    Can you help me out?

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: CountIf multiple cells

    String = cell1 & "|" & cell2  & "|" & Cell3  & "|" & cell4
    
    if String = a|||1 then *************
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

+ 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] CountIF returning results to multiple cells
    By mroberts in forum Excel General
    Replies: 7
    Last Post: 11-14-2012, 03:07 PM
  2. Countif filled cells in multiple columns
    By vascobmcastro in forum Excel General
    Replies: 6
    Last Post: 09-07-2010, 02:31 PM
  3. Replies: 0
    Last Post: 09-04-2009, 07:58 AM
  4. Countif using multiple cells
    By TJAXX in forum Excel General
    Replies: 3
    Last Post: 04-09-2007, 09:43 PM
  5. [SOLVED] using sumif & countif to sort multiple cells
    By floridasurfn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2005, 06:06 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