Say you have dates in A1:A10, and amounts in B1:B10

You can write:
=SUMPRODUCT((MONTH(A1:A10)=7)*B1:B10)

to get the summation of all amounts pertaining to the month of july

HTH
--
AP

"Cammy" a écrit dans le message de news:
...
Hello there, I am trying to do a vlookup type function which will
recognise
dates within a range (ie per month) and then do a sum function on another
column. Is it possible to do this, or do I need to write a macro? If I
need a
macro how would I go about formuling the code?