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

 

[Pecoflyer]

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

=sumproduct((a1:a10>datevalue("01/10/08"))*(a1:a10<datevalue("31/10/08"))*(b1:b10="C
Check")*c1:c10)

Amend the ranges to suit your needs keeping in mind they HAVE to be the
same length


--
Pecoflyer

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows file
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faster

 

[Raggy]

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