+ Reply to Thread
Results 1 to 4 of 4

countif question

  1. 04-09-2007, 03:48 PM #1
    pentatonic145
    pentatonic145 is offline
    Registered User
    Join Date
    04-17-2006
    Posts
    40

    countif question

    HI

    I need to know how to calculate daily surveys for each person.

    So if the date in column C equals the date in cell J2 then I need it to add all the intials for "AP" in column H and so on for each person in that column. Make sense???

    C J2 = 3/6/07 H
    3/5/07 AP
    3/6/07 AP
    3/5/07 MS

    Please help. I appreciate it
    Reply With QuoteRegister To Reply
  2. 04-09-2007, 04:17 PM #2
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    =sumproduct(--(C1:C100=J2),--(D1:D100="AP))
    Reply With QuoteRegister To Reply
  3. 04-09-2007, 04:20 PM #3
    pentatonic145
    pentatonic145 is offline
    Registered User
    Join Date
    04-17-2006
    Posts
    40

    that worked

    Thank you so much for your help.
    Reply With QuoteRegister To Reply
  4. 04-09-2007, 04:35 PM #4
    BigBas
    BigBas is offline
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127
    Im glad I could help.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1