squidmark
Board Regular
- Joined
- Aug 1, 2007
- Messages
- 105
In column A is a list of transaction types (ACH, Check, Sweep Buy, etc). In column B is the transaction amount. There are about 2000 rows.
In another cell, I want to sum ONLY the ACH transactions that are for less than $100. A SUMIF(, of course, sums all the ACH transaction amounts. How do I do a sumif that will essentially be a sumif(a:a,"ACH",b:b), but ONLY do sum the ACH transactions of less than $100?
thanks
In another cell, I want to sum ONLY the ACH transactions that are for less than $100. A SUMIF(, of course, sums all the ACH transaction amounts. How do I do a sumif that will essentially be a sumif(a:a,"ACH",b:b), but ONLY do sum the ACH transactions of less than $100?
thanks