How can i sum up numbers which are counted on a date.
ok, so if your Sheet1 contains in columns A1:B5
14/02/2007 3
15/02/2007 2
01/03/2007 1
03/05/2007 5
02/03/2007 3
and Sheet3 contains in range A1:A3
01/02/2007
01/03/2007
01/05/2007
then the formula in range B1:B3 should be:
{=SUM(IF(MONTH(A1)=MONTH(Sheet1!$A$1:$A$5),Sheet1! $B$1:$B$5))}
(again an array formula). I tried this using SUMIF, but it didn't like it.
:(
|