+ Reply to Thread
Results 1 to 2 of 2

Count if numbers in cell to left

  1. 08-28-2008, 06:05 PM #1
    Nadir Soofi
    Nadir Soofi is offline
    Registered User
    Join Date
    04-07-2008
    Posts
    27

    Count if numbers in cell to left

    All,

    I need a formula that will count numbers in column B:B if there is a number in A:A

    Thanks
    Reply With QuoteRegister To Reply
  2. 08-28-2008, 09:22 PM #2
    sglife
    sglife is offline
    Valued Forum Contributor
    Join Date
    08-26-2008
    Location
    singapore
    Posts
    626
    I can only tell you maybe you can add a third column

    =IF(ISNUMBER(A26),B26,0)

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. right & left arrows to move from cell to cell
    By oldtracy in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-01-2007, 03:04 PM
  2. Search for numbers in a cell that also contains text
    By Phoenix in forum Excel General
    Replies: 6
    Last Post: 05-03-2007, 07:02 AM
  3. cell format of numbers
    By joshtex in forum Excel General
    Replies: 3
    Last Post: 03-23-2007, 03:47 PM
  4. Count in a cell where there is several words...
    By koda86 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-27-2007, 05:26 PM
  5. count number of text or numbers in a cell?
    By japorms in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-25-2007, 05:35 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1