Formula to look for multiple criteria and bring back total

[Mldeuser]

Hello

I am looking for a formula that will look at multiple criteria in column A and sum the totals in column C.

Column A Column C
625-100-00 100.00
610-000-00 50.00
625-900-00 200.00

The total of 350 would be calculated. Some cells may need to bring back the total for 60 different codes in column A

Thank you

 

[daregu]

Not sure if this helps you or not. Cells C2-C7 can be your criteria, I wasn't sure how many criteria you needed but you can adjust that by just changing the range.

 

[Mldeuser]

The rows for the select criteria will change each month and will never be grouped together. There are about 300 rows that have different criteria in column A. I am hoping there is a simpler formula the stringing together multiple SumIF(s)

 

[cathmi]

Hi,
I have an excel file with the following data:
Sheet 1: detail data, including Customer code, DIC, Revenue, etc.
Sheet 2: Customer information including Customer code, Capital amount, Established < 1Y, etc. If customer is established < 1Y, it will be stick "x" in the field Established <1Y.
==> Formulas: Calculate the total Revenue of all Customers who is established < 1Y. This formula is placed in Sheet 3.
Could you please help me to make this formula?
Thank you so much.