sumif

  • Thread starter Thread starter Raggy
  • Start date Start date
R

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
 
Hi,

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

Where

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

Mike
 
Back
Top