Closed Thread
Results 1 to 2 of 2

COUNTIFS Function - HELP

  1. #1
    Registered User
    Join Date
    05-14-2014
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    50

    COUNTIFS Function - HELP

    Hi Guys,

    I'm trying to use the countif function to display the number of cells with certain text in them.

    for example:

    Column A will have either Car, Bike or Van in the cells and column B will have a date.

    But I want to work out how many Car and Bike are on date 01/01/2015

    This works:
    Please Login or Register  to view this content.
    but is there an easier way for example (I have tried it but doesn't work):
    Please Login or Register  to view this content.
    I don't have to use the countif function if there is a better function/formula to use

    Thanks for any help!

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,945

    Re: COUNTIFS Function - HELP

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. CountIFS Function
    By colegerald38 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-13-2015, 09:31 AM
  2. COUNTIF/COUNTIFS function + nested user-defined function
    By shamjamali in forum Excel General
    Replies: 1
    Last Post: 05-12-2015, 09:12 PM
  3. Use COUNTIFS function on results of DATEVALUE function?
    By Si902 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-16-2015, 08:13 PM
  4. Countifs function in vba
    By Sugisenthil in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-27-2015, 04:56 AM
  5. Help with a countifs function
    By GREYWOLF77 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2014, 11:06 AM
  6. Replies: 0
    Last Post: 12-16-2011, 09:01 AM
  7. countifs function
    By doowop5000 in forum Excel General
    Replies: 3
    Last Post: 06-18-2010, 04:13 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