I m trying using sumif() only positive nuber which satisfied given citerion, but im getting result "0". CAn anybody help me. Formula i have entered is "=sumif(A1:A100,A110&>0,B1:100)".
Here i m first trying to sum all cells in ranges which is equal to cell A110 & greater than zero, but i got only donuts??
A mighty flame followeth a tiny sparkle!!
=SUMPRODUCT(--(A1:A100=A110),--(B1:B100>0),B1:B100)
I have found this formula =SUMPRODUCT[A1:A100, (A1:A100>0)*(B1:B100=A169)] it is workinOriginally Posted by xld
Can you explain me yr formula step by step. it is very short. IS it possible to combining sumif() fn with other??
A mighty flame followeth a tiny sparkle!!
Hi Excelliot,
In your initial post you appear to be trying to sumif two different arrays. Bob has suggested that you use the SUMPRODUCT procedure to do so.
Your first array is A1:A100 = A110 and the second being B1:B100>0. By using Sumproduct you can use up to 255 arrays in the formula.
Please refer to the help file of Excel for an example of how this is completed.
Ted
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
what is use of "--" (that two dashes) in that 4mula
A mighty flame followeth a tiny sparkle!!
I think -- sign indicates that this is dependent condition??
A mighty flame followeth a tiny sparkle!!
See http://xldynamic.com/source/xld.SUMPRODUCT.html
Posting Permissions
Reply With Quote
