Array Formula trouble

[ike92]

I am using Excel 2010 and am having trouble using an array formula with multiple criteria. Here are a couple of the cells below.
a b c

State	Firm	Assets
PA	Apollo	25000
NY	CDD	9001
WI	Apollo	68999
CA	CPA	8888
MI	Apollo	232323
VA	Apollo	43000

<tbody>
</tbody>

I am using these three columns in the array.

I need to find the sum of the assets based on the firm in certain states.
For example, I need to find the sum of the assets for Apollo in PA, WI and VA.

Right now, this is the formula I am using, and it is returning 0.

{=sum(if(and(A:A="Apollo", or(B:B="PA", B:B="WI", B:B="VA")) C:C))}

What is the correct function to find the sum of the assets?

Thank you so much in advance!

 

[Jonmo1]

Welcome to the board.

Try
=SUM(SUMIFS(C1:C100,A1:A100,"Apollo",B1:B100,{"PA","WI","VA"}))

 

[ike92]

Thanks! This helped a lot! Have a great day!