=SUMPRODUCT(--(C:C="Jack")--(A:A>=DATE(2005,10,1)),--(A:A<=DATE(2005,12,31)))
How can I modify this to look for Jack, or Hurley, or John, or Sawyer?
Thanks a lot!
Bryce
=SUMPRODUCT(--(C:C="Jack")--(A:A>=DATE(2005,10,1)),--(A:A<=DATE(2005,12,31)))
How can I modify this to look for Jack, or Hurley, or John, or Sawyer?
Thanks a lot!
Bryce
Last edited by bkatzman; 04-01-2010 at 10:16 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks