Sumproduct Help PLEASE

  • Thread starter Thread starter Guest
  • Start date Start date
Hi,

Maybe

=SUMPRODUCT((B2:B100=E1)*(D2:D100>=F1)*(D2:D100<=G1)*A2:A100)

Where
E1 = Name to find
F1 = Quarter start date
G1 = Quarter end date

Mike
 
Back
Top