Results 1 to 5 of 5

COUNTIFS to count data in two columns based on other criteria?

Threaded View

  1. #1
    Registered User
    Join Date
    08-02-2009
    Location
    Lancashire, England
    MS-Off Ver
    Excel 2007
    Posts
    84

    Smile COUNTIFS to count data in two columns based on other criteria?

    Hi

    Im having problems with COUNTIFS and multiple criteria. I am trying to count the number of times a name appears in two columns D:E, this based on the date (Month / Year),
    The formula is on the "Stats" sheet, along with the cells to select the Year etc.

    Im struggling to describe well so i have attached a copy to show what i mean (unfortunately have had to sanitise it somewhat). There is a note in the relevant cell.

    Hope you can help (you have never let me down before)!

    Thanks in advance.

    Si
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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