Cleanest Way to Use Sumif adding multiple critera?

[MikeWeaver]

I am looking for the cleanest way to sum everything in one column of a worksheet that meets the criteria for "Revenue" , or "Expense", my revenue column could actually have 10 or 12 line items so I am looking for the cleanest and shortest formula to do this. Thanks so much for any help you can give!

I have my table like this (simplified example):

Class				Total
Revenue	Shoe Sales	Other Revenue	Sock Sales
Expenses	Blah	Blah Blah

<tbody>
</tbody>

and financials like this (simplified example):

Shoe Sales	50
Other Revenue	100
Operating Expense	12
Sock Sales	20
Blah	10
Blah Blah	10

<tbody>
</tbody>

 

[MikeWeaver]

Oh, Ok.

Then for Revenue it would be
=SUM(SUMIF(A1:A100,{"Sock Sales","Shoe Sales","Other Revenue"},B1:B100))

and for Expenses
=SUM(SUMIF(A1:A100,{"Expenses","Blah","Blah Blah"},B1:B100))

To use a Range for the criteria, say E2:G2
Try
=SUMPRODUCT(SUMIF(A1:A100,E2:G2,B1:B100))

That works perfectly. Thank you. I'm naming my first child Jonmo1.