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
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]State[/TD]
[TD]Firm[/TD]
[TD]Assets[/TD]
[/TR]
[TR]
[TD]PA[/TD]
[TD]Apollo[/TD]
[TD]25000[/TD]
[/TR]
[TR]
[TD]NY[/TD]
[TD]CDD[/TD]
[TD]9001[/TD]
[/TR]
[TR]
[TD]WI[/TD]
[TD]Apollo[/TD]
[TD]68999[/TD]
[/TR]
[TR]
[TD]CA[/TD]
[TD]CPA[/TD]
[TD]8888[/TD]
[/TR]
[TR]
[TD]MI[/TD]
[TD]Apollo [/TD]
[TD]232323[/TD]
[/TR]
[TR]
[TD]VA[/TD]
[TD]Apollo[/TD]
[TD]43000[/TD]
[/TR]
</tbody>[/TABLE]

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!