+ Reply to Thread
Results 1 to 3 of 3

Multi Condition SUM

  1. #1
    Registered User
    Join Date
    11-20-2006
    Posts
    1

    Multi Condition SUM

    I am summing data in E3:E85 based on dates contained in B3:b85 and it works great:

    =SUMPRODUCT(--(B3:B85>=B90),--(B3:B85<=C90),--(E3:E85))

    Where B90 contains my Beginning Date "11/1/2006" and C90 my End Date 11/30/2006

    I also need to have this same information specific to various people's name's
    contained in D:3:D85 (Linda, Sue, Debbie)

    Anyone know how to add this condition

  2. #2
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi

    Please Login or Register  to view this content.
    HTH
    Carim

  3. #3
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi

    Please Login or Register  to view this content.
    HTH
    Carim

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1