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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to expand Index/Match formula 2
sumproduct Formula PLEASE HELP 7
Sum of Cells if Row Contains a Specific Variable 3
Formula Help 1
Sum If? Help 1
Sum with multiple conditions 6
Is this an Index/Match formula? 5
spread out fields in different column 1

Back
Top