banneduser123
Banned - Rules violations
- Joined
- Mar 29, 2006
- Messages
- 181
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...
=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...