software

I have a two colums with values, A contains numbers from 1 to 10, B contains
numerique values. Now I would like to make the sum of the values in B
depending on the value in A, e.g. sum of all values in B fot which the
content in A lt; 5

Try something like this:

C1: =SUMIF(A:A,quot;lt;5quot;,B:B)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;bloopquot; wrote:

gt; I have a two colums with values, A contains numbers from 1 to 10, B contains
gt; numerique values. Now I would like to make the sum of the values in B
gt; depending on the value in A, e.g. sum of all values in B fot which the
gt; content in A lt; 5

=SUMPRODUCT(--(A1:A10lt;5),--(B1:B10))

Roberto

quot;bloopquot; gt; ha scritto nel messaggio
news
:I have a two colums with values, A contains numbers from 1 to 10, B contains
: numerique values. Now I would like to make the sum of the values in B
: depending on the value in A, e.g. sum of all values in B fot which the
: content in A lt; 5
Yes that was it! thanks so much!

bloop

quot;Robertoquot; wrote:

gt; =SUMPRODUCT(--(A1:A10lt;5),--(B1:B10))
gt;
gt; Roberto
gt;
gt; quot;bloopquot; gt; ha scritto nel messaggio
gt; news
gt; :I have a two colums with values, A contains numbers from 1 to 10, B contains
gt; : numerique values. Now I would like to make the sum of the values in B
gt; : depending on the value in A, e.g. sum of all values in B fot which the
gt; : content in A lt; 5
gt;
gt;
gt;

Sorry, I was to fast, this method works also!

Thank you very much!

Bloop

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; C1: =SUMIF(A:A,quot;lt;5quot;,B:B)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;bloopquot; wrote:
gt;
gt; gt; I have a two colums with values, A contains numbers from 1 to 10, B contains
gt; gt; numerique values. Now I would like to make the sum of the values in B
gt; gt; depending on the value in A, e.g. sum of all values in B fot which the
gt; gt; content in A lt; 5

No, no. Ron gave you the proper answer.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;bloopquot; gt; wrote in message
...
gt; Yes that was it! thanks so much!
gt;
gt; bloop
gt;
gt; quot;Robertoquot; wrote:
gt;
gt; gt; =SUMPRODUCT(--(A1:A10lt;5),--(B1:B10))
gt; gt;
gt; gt; Roberto
gt; gt;
gt; gt; quot;bloopquot; gt; ha scritto nel messaggio
gt; gt; news
gt; gt; :I have a two colums with values, A contains numbers from 1 to 10, B
contains
gt; gt; : numerique values. Now I would like to make the sum of the values in B
gt; gt; : depending on the value in A, e.g. sum of all values in B fot which the
gt; gt; : content in A lt; 5
gt; gt;
gt; gt;
gt; gt;

quot;Bob Phillipsquot; gt; ha scritto nel messaggio
...
: No, no. Ron gave you the proper answer.
:
Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
Roberto
Because it is optimised for conditional counting, so when you only have one
condition, use SUMIF. SUMPRODUCT is good for multiple conditions, but the --
is coercing a TRUE/FALSE result to 1/0 so that it can do the product can be
executed. It also looks more intuitive, no --.

I just did a quick test, and in this SUMIF was quicker than SUMPRODUCT by a
factor of some 42%.

That is why it is better in the right circumstances.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;Robertoquot; lt;schebobchiocciolatinpuntoitgt; wrote in message
...
gt;
gt; quot;Bob Phillipsquot; gt; ha scritto nel
messaggio
gt; ...
gt; : No, no. Ron gave you the proper answer.
gt; :
gt; Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
gt; Roberto
gt;
gt;
Hi,

You may use a sum(if( array formula (Ctrl Shift Enter)

=sum(if(rangeAlt;=5,rangeB))

Regards,

quot;bloopquot; wrote:

gt; I have a two colums with values, A contains numbers from 1 to 10, B contains
gt; numerique values. Now I would like to make the sum of the values in B
gt; depending on the value in A, e.g. sum of all values in B fot which the
gt; content in A lt; 5

Thanks for your answer, Bob.
Roberto

quot;Bob Phillipsquot; gt; ha scritto nel messaggio
...
: Because it is optimised for conditional counting, so when you only have one
: condition, use SUMIF. SUMPRODUCT is good for multiple conditions, but the --
: is coercing a TRUE/FALSE result to 1/0 so that it can do the product can be
: executed. It also looks more intuitive, no --.
:
: I just did a quick test, and in this SUMIF was quicker than SUMPRODUCT by a
: factor of some 42%.
:
: That is why it is better in the right circumstances.
:
: --
: HTH
:
: Bob Phillips
:
: (remove nothere from email address if mailing direct)
:
: quot;Robertoquot; lt;schebobchiocciolatinpuntoitgt; wrote in message
: ...
: gt;
: gt; quot;Bob Phillipsquot; gt; ha scritto nel
: messaggio
: gt; ...
: gt; : No, no. Ron gave you the proper answer.
: gt; :
: gt; Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
: gt; Roberto
: gt;
: gt;
:
: