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
Bookmarks