multiple criteria then sum

Hi

One option is to use SUMPRODUCT. There is some guidance here:
http://www.contextures.com/xlFunctio...tml#SumProduct

In your example, something like:
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
When using this function, each range must contain the same number of cells
and cannot be full columns.

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
>I am trying to figure out how to sum a column based on 2 criteria being
>true.
>
> criteria1 criteria2 volume
> 3 2 100
> 2 2 500
> 2 1 600
> 3 2 200
>
> For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> =
> 2 simultanously. In this example, volume would equal 300.
>
> Any suggestions?
>

What if you have two criteria and want to sum the same column?
I tried
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
and got a VALUE error

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Hi

I've just tried it and it worked for me!! Make sure that your 'numbers' are
actually numbers and not text.

Andy.

"DG" <[email protected]> wrote in message
news:[email protected]...
> What if you have two criteria and want to sum the same column?
> I tried
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
> and got a VALUE error
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>

Many thanks Andy! I tried it and it works nicely. I will check out the link
as well....

Regards, Kit

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Thanks for the feedback!!

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
> Many thanks Andy! I tried it and it works nicely. I will check out the
> link
> as well....
>
> Regards, Kit
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>

Hi

One option is to use SUMPRODUCT. There is some guidance here:
http://www.contextures.com/xlFunctio...tml#SumProduct

In your example, something like:
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
When using this function, each range must contain the same number of cells
and cannot be full columns.

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
>I am trying to figure out how to sum a column based on 2 criteria being
>true.
>
> criteria1 criteria2 volume
> 3 2 100
> 2 2 500
> 2 1 600
> 3 2 200
>
> For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> =
> 2 simultanously. In this example, volume would equal 300.
>
> Any suggestions?
>

What if you have two criteria and want to sum the same column?
I tried
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
and got a VALUE error

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Hi

I've just tried it and it worked for me!! Make sure that your 'numbers' are
actually numbers and not text.

Andy.

"DG" <[email protected]> wrote in message
news:[email protected]...
> What if you have two criteria and want to sum the same column?
> I tried
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
> and got a VALUE error
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>

Many thanks Andy! I tried it and it works nicely. I will check out the link
as well....

Regards, Kit

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Thanks for the feedback!!

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
> Many thanks Andy! I tried it and it works nicely. I will check out the
> link
> as well....
>
> Regards, Kit
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>

I am trying to figure out how to sum a column based on 2 criteria being true.

criteria1 criteria2 volume
3 2 100
2 2 500
2 1 600
3 2 200

For example, I want the sum for volume when criteria 1 = 3 and criteria 2 =
2 simultanously. In this example, volume would equal 300.

Any suggestions?

Hi

One option is to use SUMPRODUCT. There is some guidance here:
http://www.contextures.com/xlFunctio...tml#SumProduct

In your example, something like:
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
When using this function, each range must contain the same number of cells
and cannot be full columns.

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
>I am trying to figure out how to sum a column based on 2 criteria being
>true.
>
> criteria1 criteria2 volume
> 3 2 100
> 2 2 500
> 2 1 600
> 3 2 200
>
> For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> =
> 2 simultanously. In this example, volume would equal 300.
>
> Any suggestions?
>

What if you have two criteria and want to sum the same column?
I tried
=SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
and got a VALUE error

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Hi

I've just tried it and it worked for me!! Make sure that your 'numbers' are
actually numbers and not text.

Andy.

"DG" <[email protected]> wrote in message
news:[email protected]...
> What if you have two criteria and want to sum the same column?
> I tried
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),B2:B10)
> and got a VALUE error
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>

Many thanks Andy! I tried it and it works nicely. I will check out the link
as well....

Regards, Kit

"Andy" wrote:

> Hi
>
> One option is to use SUMPRODUCT. There is some guidance here:
> http://www.contextures.com/xlFunctio...tml#SumProduct
>
> In your example, something like:
> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
> When using this function, each range must contain the same number of cells
> and cannot be full columns.
>
> Andy.
>
> "Kit" <[email protected]> wrote in message
> news:[email protected]...
> >I am trying to figure out how to sum a column based on 2 criteria being
> >true.
> >
> > criteria1 criteria2 volume
> > 3 2 100
> > 2 2 500
> > 2 1 600
> > 3 2 200
> >
> > For example, I want the sum for volume when criteria 1 = 3 and criteria 2
> > =
> > 2 simultanously. In this example, volume would equal 300.
> >
> > Any suggestions?
> >
>
>
>

Thanks for the feedback!!

Andy.

"Kit" <[email protected]> wrote in message
news:[email protected]...
> Many thanks Andy! I tried it and it works nicely. I will check out the
> link
> as well....
>
> Regards, Kit
>
> "Andy" wrote:
>
>> Hi
>>
>> One option is to use SUMPRODUCT. There is some guidance here:
>> http://www.contextures.com/xlFunctio...tml#SumProduct
>>
>> In your example, something like:
>> =SUMPRODUCT((A2:A10=3)*(B2:B10=2),C2:C10)
>> When using this function, each range must contain the same number of
>> cells
>> and cannot be full columns.
>>
>> Andy.
>>
>> "Kit" <[email protected]> wrote in message
>> news:[email protected]...
>> >I am trying to figure out how to sum a column based on 2 criteria being
>> >true.
>> >
>> > criteria1 criteria2 volume
>> > 3 2 100
>> > 2 2 500
>> > 2 1 600
>> > 3 2 200
>> >
>> > For example, I want the sum for volume when criteria 1 = 3 and criteria
>> > 2
>> > =
>> > 2 simultanously. In this example, volume would equal 300.
>> >
>> > Any suggestions?
>> >
>>
>>
>>