Hi
something like this:
=SUMPRODUCT(--(A2:A100=DATE(2004,1,1)),--(A2:A100<=DATE(2005,1,15)),B2:B100
)
NB! You can't use references like 'A:A' with SUMPRODUCT - the ranges must be
exactly defined, and all of same dimension.
Arvi Laanemets
"Ket" wrote in message
...
Hello,
I have looked through the threads and believe what I require is the
SUMPRODUCT function.
I have a spreadsheet with column A containing dates in the format
dd/mm/yyyy and column B containing values.
What formula should I use in column C that will add up all deals
between two dates?
Eg between 01/01/2004 and 15/01/2005 ?
TIA for your help.
Ket
London
|