complex logical arguments when summing data

[Richard]

Hi
I need to sum a long list of costs sorted by year and cost
type, but only those a meet a certain critera.

If I was about to sum all costs per year I would be home
free using SUMIF like SUMIF(A:A,"2003", D) where col A
is Year and col D is the cost.

I would like to sum all costs per year AND cost type. To
express the condition in order to make it visible
in "plain english":

Type (begins with $OM OR OMS) AND Year=2002.


I have tried to use SUMIF like but I can't get it to work.
I suppose it's not built for this?

Is there anyone who knows how to solve this kind of
problems?

Thanks in advance!

Best regards
Richard

 

[Don Guillett]

=sumproduct((a2:a200="2003")*(b2:b200="whatevercosttype")*c2:c200)