Summation with 2 different conditions - SUMPRODUCT Can't work in this example
Hi,
Sorry, I left out one important condition which resulted in the closure of the last thread.
I had a solution to count with 2 conditions but I can't do the following summation with 2 conditions.
Example:
A1 = Apple
A2 = Pear
A3 = Orange
A4 = Starfruit
A5 = Apple
A6= Apple
C1 = 1
C2 = 2
C3 = 3
C4 = 4
C5 = 5
C6= 6
D1 = SUM any value that is greater than 2 that belongs to "Apple" row, = C5+C6 = 11
hey man why are u asking again & again same question.have u try below post formulas ???
http://www.excelforum.com/excel-gene...onditions.html
Re: Summation with 2 different conditions - SUMPRODUCT Can't work in this example
Good afternoon
What have you got against SUMPRODUCT?
Something like this should work fine :
=SUMPRODUCT(--(A1:A6="Apple"),--(C1:C6>2),(C1:C6))
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Hi,Originally Posted by johncena
yes I did try but =SUMPRODUCT((A1:A6="Apple")*(B1:B6>0)) only counted the apples.
Now it's summation of another column and the summation is only done if it is greater than 2, thus C1's value is left out.
I tried =SUMIF(A1:A6,"Apple",(AA10:AA73)>2) but excel pops out error message.
Re: Summation with 2 different conditions - SUMPRODUCT Can't work in this example
Hi Dominic! You are my saviour!!!
I didn't read about the -- in help. Where can I read more about using SUMPRODUCT? What does "--" mean?
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
Re: Summation with 2 different conditions - SUMPRODUCT Can't work in this example
Hi Lewis Koh
contaminated's link is a great start to the dark and mysterious world of SUMPRODUCT, but it is quite in depth. I attempted to put the way the unary minus (as the double minus is correctly termed) works to Valued Forum Contributor corinereyes as simply as possible in post 9 of this thread.
HTH
DominicB
The double minus is actually two unary negation operators. It's Excels highest-priority arithmetic operator, which drives mathematicians who think =-4^2 should be -16 (i.e., -1 * 4^2) instead of 16 (what Excel returns, (-4)^2)) crazy.the unary minus (as the double minus is correctly termed)
Last edited by shg; 04-18-2010 at 08:08 PM.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks