Hi
try
=SUMPRODUCT(--(MONTH(A1:A100=10),--(YEAR(A1:A100=2004),B1:B100)
--
Regards
Frank Kabel
Frankfurt, Germany
"Chris" schrieb im Newsbeitrag
...
I have a column with dates and another with totals. I want to for
every month
(01 - 12) to search all the rows in columnA and sum the totals only
relevent
to the month from columnB. E.g for OCtober the total is 1500
ColumnA columnB
10/10/04 1000
10/10/04 500
10/09/04 250
|