sumproduct (Bob and/or Frank)

  • Thread starter Thread starter GerryK
  • Start date Start date
G

GerryK

Hi Bob and Frank
Thanks for your help. My results are now different but
still unpredictable!

Maybe I can incorporate a simple solution on my own if
there is one that you could provide direction for!

At the simplest level:
Column J are amounts.
Column D are dates in format(mm/dd/yyyy)
What formula or syntax could I use to add amounts from J
when two dates are entered in separate cells in mm/dd/yyyy
format?

In other words if I enter in A1 1/2/2004 and in B1
1/15/2004 I'd like to get a total out of J but only the
records linked to D that are between the dates specified.
Am I looking at a VLOOKUP type of logic?

TIA
Gerry
 
Hi
try
=SUMPRODUCT((D1:D999>A1)*(D1:D999<B1),J1:J999)

P.s.: you should try to stay in the same thread if you have a follow up
questions :-)
 
Just to be different from Frank

=SUMPRODUCT((D1:D999>=A1)*(D1:D999<=B1),J1:J999)

to include that date.

But I agree with the thread comment.


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top