Results 1 to 3 of 3

Excel 2007 : Help with countif formula

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2012
    Location
    Fort Payne, Alabama
    MS-Off Ver
    office 2007
    Posts
    2

    Help with countif formula

    Can anyone help me with the correct formula I would need to enter to count non duplicate cells in column a (cells range from a2 to a251) if b2 to b251 equals "jeff".

    I have read in other forums that I can use the advanced filter option to create a copy of cells with the duplicate cells ommitted and then count them but I have quite a few names to sort by and would like excel to just spit out a number for me so i can enter it into a monthly bar graph already created.

    Thanks in advance for all your help.
    Last edited by bkswhite; 03-06-2012 at 04:15 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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