+ Reply to Thread
Results 1 to 2 of 2

What formula?

  1. #1
    Registered User
    Join Date
    09-05-2008
    Location
    London, UK
    Posts
    17

    What formula?

    These are my columns, I have only included the ones that I'm using.

    B G L AI
    name address Postcode [Formula] either "1" or "0"

    =IF((OR(G10="", L10="")), "0","1")

    I have about 14,000 rows and about 500 different names in column B, what I'm looking to do is find the count of "1"s in column AI with a specific name from Column B.

    I don't what formula to use or who to contstruct it? Can someone help?

    Does that make sense?

  2. #2
    Forum Contributor
    Join Date
    09-23-2008
    Location
    UK
    Posts
    137
    I'd create a new column (say column M) and set this to

    M1=A1&AI1

    Then for example if you want to know all the people called martin with a column AI result of 1 then do:

    =countif(M:M,"martin1")


    (I am assuming AI is the column where you have your formula)

+ 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. Formula for bond price
    By Dracan in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 04-15-2014, 11:17 AM
  2. A formula template
    By ajaysehgal in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-07-2013, 06:12 AM
  3. Reset Formula without Editing Formula?
    By Ogey in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-27-2007, 08:44 PM
  4. Conditional formula question
    By odditie in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-27-2007, 09:47 PM
  5. use cell content as cell address in formula
    By nnsc in forum Excel General
    Replies: 4
    Last Post: 11-05-2006, 03:12 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1