Excel conditional sum
 

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 < 5

Excel conditional sum
 

Try something like this:

C1: =SUMIF(A:A,"<5",B:B)

Does that help?

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

XL2002, WinXP-Pro


"bloop" wrote:

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 < 5

Excel conditional sum
 

=SUMPRODUCT(--(A1:A10<5),--(B1:B10))

Roberto

"bloop" ha scritto nel messaggio
...
: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 < 5

Excel conditional sum
 

Yes that was it! thanks so much!

bloop

"Roberto" wrote:

=SUMPRODUCT(--(A1:A10<5),--(B1:B10))

Roberto

"bloop" ha scritto nel messaggio
...
: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 < 5

Excel conditional sum
 

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

Thank you very much!

Bloop

"Ron Coderre" wrote:

Try something like this:

C1: =SUMIF(A:A,"<5",B:B)

Does that help?

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

XL2002, WinXP-Pro


"bloop" wrote:

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 < 5

Excel conditional sum
 

No, no. Ron gave you the proper answer.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"bloop" wrote in message
...
Yes that was it! thanks so much!

bloop

"Roberto" wrote:

=SUMPRODUCT(--(A1:A10<5),--(B1:B10))

Roberto

"bloop" ha scritto nel messaggio
...
: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 < 5

Excel conditional sum
 

"Bob Phillips" ha scritto nel messaggio
...
: No, no. Ron gave you the proper answer.
:
Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
Roberto

Excel conditional sum
 

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)

"Roberto" <schebobchiocciolatinpuntoit wrote in message
...

"Bob Phillips" ha scritto nel
messaggio
...
: No, no. Ron gave you the proper answer.
:
Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
Roberto

Excel conditional sum
 

Hi,

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

=sum(if(rangeA<=5,rangeB))

Regards,

"bloop" wrote:

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 < 5

Excel conditional sum
 

Thanks for your answer, Bob.
Roberto

"Bob Phillips" 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)
:
: "Roberto" <schebobchiocciolatinpuntoit wrote in message
: ...
:
: "Bob Phillips" ha scritto nel
: messaggio
: ...
: : No, no. Ron gave you the proper answer.
: :
: Just to improve my Excel: why SUMIF is better than SUMPRODUCT?
: Roberto
:
:
:
: