I am trying to figure out how to do the following. I am trying to get a sum
of numbers in a column, but the numbers need to fit certain criteria. For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and "and"
statement, but i'm not sure how to word this. Could someone Please help!

Couple of ways:

=Sumif(A1:A500,"=40")-Sumif(A1:A500,"60")

OR

=Sumproduct((A1:A500=40)*(A1:A500<=60)*A1:A500)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_vegas" wrote in message
...
I am trying to figure out how to do the following. I am trying to get a
sum
of numbers in a column, but the numbers need to fit certain criteria. For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and
"and"
statement, but i'm not sure how to word this. Could someone Please help!

Thank you very much!

"Ragdyer" wrote:

Couple of ways:

=Sumif(A1:A500,"=40")-Sumif(A1:A500,"60")

OR

=Sumproduct((A1:A500=40)*(A1:A500<=60)*A1:A500)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_vegas" wrote in message
...
I am trying to figure out how to do the following. I am trying to get a
sum
of numbers in a column, but the numbers need to fit certain criteria. For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and
"and"
statement, but i'm not sure how to word this. Could someone Please help!

-- What if the scenario were the Criteria was in column 1 let us say account
name then the amount was in column 5 and you needed to add all for a
particular account name?

joromajr


"Ragdyer" wrote:

Couple of ways:

=Sumif(A1:A500,"=40")-Sumif(A1:A500,"60")

OR

=Sumproduct((A1:A500=40)*(A1:A500<=60)*A1:A500)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_vegas" wrote in message
...
I am trying to figure out how to do the following. I am trying to get a
sum
of numbers in a column, but the numbers need to fit certain criteria. For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and
"and"
statement, but i'm not sure how to word this. Could someone Please help!

You could choose from either of the same 2 functions:

=Sumif(A1:A500,"Acctname",E1:E500)

Or

=Sumproduct((A1:A500="Acctname")*E1:E500)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"joromajr" wrote in message
...

-- What if the scenario were the Criteria was in column 1 let us say
account
name then the amount was in column 5 and you needed to add all for a
particular account name?

joromajr


"Ragdyer" wrote:

Couple of ways:

=Sumif(A1:A500,"=40")-Sumif(A1:A500,"60")

OR

=Sumproduct((A1:A500=40)*(A1:A500<=60)*A1:A500)
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"B_vegas" wrote in message
...
I am trying to figure out how to do the following. I am trying to get
a
sum
of numbers in a column, but the numbers need to fit certain criteria.
For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and
"and"
statement, but i'm not sure how to word this. Could someone Please
help!

You're welcome, and appreciate the feed-back.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"B_vegas" wrote in message
...
Thank you very much!

"Ragdyer" wrote:

Couple of ways:

=Sumif(A1:A500,"=40")-Sumif(A1:A500,"60")

OR

=Sumproduct((A1:A500=40)*(A1:A500<=60)*A1:A500)
--
HTH,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"B_vegas" wrote in message
...
I am trying to figure out how to do the following. I am trying to get
a
sum
of numbers in a column, but the numbers need to fit certain criteria.
For
example;

I have 500 numbers in a column ranging from 1 to 130
I need the sum of only the numbers between 40 and 60.

I figure that this involves the sum function and some type of "if" and
"and"
statement, but i'm not sure how to word this. Could someone Please
help!