Results 1 to 9 of 9

How to use CountIF and VlookUps properly.

Threaded View

  1. #1
    Registered User
    Join Date
    07-20-2013
    Location
    Anaheim, CA
    MS-Off Ver
    MS365
    Posts
    63

    How to use CountIF and VlookUps properly.

    Hello,

    I have almost been able to finish this project. Please help ! On my attachment, there is 2 sheets. Stores and TAB. The stores sheet has all the data....but in the TAB sheet, i am hoping to get help on the correct formulas to enter into Table 3 which starts on cell C31. if the goal has been set at 95% on D31 which formula can i enter so that it can tell me which region names have 95% or better on column O - in the STORES sheet. and on cell to calculate how much over did it go beyond 95%. Then to count the number of stores achieving the 95% threshold...based off of column O. Please help!

    Thank u for your time.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to properly use CountIf and vlookups.
    By dmejia174 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-28-2013, 07:37 PM
  2. Replies: 3
    Last Post: 07-26-2013, 01:22 AM
  3. Countif, not functioning properly
    By tradeform2 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 05:45 PM
  4. [SOLVED] HLookup and VLookups, including countif
    By genichigo in forum Excel General
    Replies: 7
    Last Post: 05-03-2012, 07:53 AM
  5. COUNTIF not counting properly!! Character limit?
    By kytihu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-30-2006, 12:45 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