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