Results 1 to 5 of 5

Count based on rows and columns

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2007
    Posts
    38

    Count based on rows and columns

    I have a data table with two columns (surveillance #, date). I would like to count the number of times a particular surveillance # occured during a particular month, without doing a pivot table. In the attached example cell E2 i have the following equation

    =LOOKUP(2,1/(($D2=$A$2:$A$50)*(MONTH(E$1)=MONTH($B$2:$B$50))*(YEAR(E$1)=YEAR($B$2:$B$50))))

    which results in a value of 1, but not a count of the number of times surveillance #1 occurs in the month of January. Can someone point me in the right direction for how to make this return a count?

    Any help is appreciated.

    Thanks!
    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