B bunji Registered User. Local time Today, 23:14 Joined Apr 26, 2005 Messages 124 Nov 24, 2005 #1 I would like to move sum A1:A6 If the B cell is = True and another cell is = 1. I have an attachment that shows the layout. Therefore Total = 76.7 Does that make sense? If so how could i work out the formula? Attachments example.txt example.txt 89 bytes · Views: 409
I would like to move sum A1:A6 If the B cell is = True and another cell is = 1. I have an attachment that shows the layout. Therefore Total = 76.7 Does that make sense? If so how could i work out the formula?
B bunji Registered User. Local time Today, 23:14 Joined Apr 26, 2005 Messages 124 Nov 24, 2005 #2 i have =SUMIF(B1:B6,TRUE,A1:A6) But how do i add the second criteria
B bunji Registered User. Local time Today, 23:14 Joined Apr 26, 2005 Messages 124 Nov 24, 2005 #3 Ok i did it using an array =SUM((B1:B6=True)*(C1:C6=1)*A1:A6) To Enter the array press Ctrl Shift Enter when leaving the cell. Hope this helps anyone who came across the same problem.
Ok i did it using an array =SUM((B1:B6=True)*(C1:C6=1)*A1:A6) To Enter the array press Ctrl Shift Enter when leaving the cell. Hope this helps anyone who came across the same problem.
S shades Registered User. Local time Today, 17:14 Joined Mar 25, 2002 Messages 516 Nov 25, 2005 #4 That's one way to do it. Another is to use SUMPRODUCT, which is not an array function. =SUMPRODUCT((B1:B6="True")*(C1:C6=1),A1:A6) ________ FORD KANSAS CITY ASSEMBLY PLANT PICTURE Last edited: Feb 16, 2011
That's one way to do it. Another is to use SUMPRODUCT, which is not an array function. =SUMPRODUCT((B1:B6="True")*(C1:C6=1),A1:A6) ________ FORD KANSAS CITY ASSEMBLY PLANT PICTURE
