Sum based on second column date
 

=SUMPRODUCT(--(A1:A100=DATE(2009,1,1)),--(A1:A100<=DATE(2009,3,31),
I1:I100)
will sum all the vales in I1:100 when A values are between 1Jan and 31 March

But you used the phase "specific currency"; do you mean the I values could
have say $ and £ values and you want only one of them? That will be
problematic - lets us know it this is the case. What version of Excel?

best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Abel" wrote in message
...
Please help. I am trying to sum only specific currency vales found in
column
'I' if the date foundin column 'A' falls in a specific range.