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