Results 1 to 9 of 9

CountIF and Hlook Up Togeather

Threaded View

  1. 01-20-2014, 11:42 AM #1
    sreeni85
    sreeni85 is offline
    Registered User
    Join Date
    07-17-2012
    Location
    India
    MS-Off Ver
    Excel 2000
    Posts
    2

    CountIF and Hlook Up Togeather

    I would need the count of Number 1 in the B column, I tried count IF, but still a separate Hlook up is required.

    Can someone help me out with the countif and hlookup formula in same cell.

    enclosed sample excel
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. how to use find and left togeather
    By nuruedriss in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-01-2013, 06:51 AM
  2. linking 2 work books togeather
    By Zealotwraith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-02-2013, 11:01 AM
  3. Using sumproduct and subtotal togeather ???????
    By LondonM in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2013, 10:59 AM
  4. Using Hlook up
    By pani_hcu in forum Excel General
    Replies: 1
    Last Post: 10-30-2008, 08:40 PM
  5. Help With HLOOK
    By Hummer2097 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-18-2005, 02:22 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