SUMIFs that meets one of 3 particular criterias

[banneduser123]

Hi, I have a SUMIF formula that accomplishes what I want it to:
=ROUND(SUMIF('Sheet'!$O:$O, "Common Stock", 'Sheet'!$R:$R)/1000000,0)

in that if any items says "Common stock" in column O of 'Sheet', then it will sum up the balances of all those items. (column R contains the balance)

however,


I'd like to change this formula so that it will sum up any items that meet either or 1 of multiple criteria,

meaning, if an items says either "Common stock" OR "Equities" OR "Fund" then it will sum up all those items.

Anyone know how to change my formula to accomplish this?

Hopefully I was clear...

 

[shobolos]

Excel 2010
	A
1	0
Sheet2

Cell Formulas
Range	Formula
A1	=ROUND(SUMPRODUCT(SUMIF(Sheet!O:O,{"Common Stock";"Equities";"Fund"},Sheet!R:R))/1000000,0)

 

[banneduser123]

awesome, thanks a lot!

 

[banneduser123]

I have another question.

so using the formula you gave, what if I wanted to add another criteria that is coming from a different column?

for instance, in column B it has to say 'Bank'

 

[banneduser123]

nevermind, I figured it out....thanks anyway