sumif
 

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

sumif
 

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" wrote:

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

sumif
 

Raggy;303438 Wrote:
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:a10datevalue("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
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=84867

sumif
 

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

"Mike H" wrote:

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" wrote:

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