sumif

[Raggy]

I am trying to use sumif to work out the problem below using excel 2003.

Sheet 1
Col A Col B Col C
1 Oct 08 C Check 10
4 Oct 08 C Check 2
9 Oct 08 A Check 4
1 Nov 08 C Check 5
25 Dec 08 B Check 1

I want to add all data in (Col C) if (Col B=C Check) AND (Col A is > 1 Oct
08 < 31st Oct 08)

Thanks

 

[Mike H]

Hi,

=SUMPRODUCT((A2:A20>=D2)*(A2:A20<=D3)*(B2:B20="C Check")*(C2:C20))

Where

D2=1/10/08
D3=31/10/08

Mike

 

[Raggy]

Mike,
That was quick, works well too, thanks!
Andy