Sumproduct Help PLEASE

M

Mike H

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
 
Top