I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$
a 1 3.00
a 2 5.00
b 1
c 1
d 1

My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range critera) {sum_range}) but i can't make it work
I'm missing something

Help

One way:

=Sumif(A2:A6,"a",C2:C6)+Sumif(B2:B6,1,C2:C6)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Cyn" wrote in message
...
I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$
a 1 3.00
a 2 5.00
b 1
c 1
d 1

My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range critera) {sum_range}) but i can't make it work
I'm missing something

Help

=SUMPRODUCT(--(A2:A100="a"),--(B2:B100=1),C2:C100)


"Cyn" wrote:

I need to get a sum from 2 different criteria in 2 different ranges.
PLace Type $$
a 1 3.00
a 2 5.00
b 1
c 1
d 1

My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range critera) {sum_range}) but i can't make it work
I'm missing something

Help

Try this:

=SUMPRODUCT((A1:A5="a")*(B1:B5=1)*(C1:C5))

Adjust the ranges to suit your real data.

Hope this helps.

Pete

On Aug 26, 10:44*pm, Cyn wrote:
I need to get a sum from 2 different criteria in 2 different ranges.
PLace * Type *$$
a * * * * 1 * *3.00
a * * * * 2 * *5.00
b * * * * 1 * *
c * * * * 1
d * * * * 1

My end result would be for all "a" in Place column and all "1" in Type
column then auto sum of Column $$
((Range,critera) and (range critera) {sum_range}) but i can't make it work
I'm missing something

Help