If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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:a10datevalue("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 |
#4
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|