Formula using If and AND
Hello, In this Excel file I’ve written a formula in column E that takes all of the rows where column B contain the word “Bob” (I2) and enters the amount associated with that row (Column C) into Column E (Results 1). This works fine. In column F (Results 2) I want to do the same with 2 different scenarios that both need to be met. I want to again take all of the rows where column B contain the word “Bob” (I2) AND Column D (Account) is “A” (J2). I tried this formula =IF(AND(ISNUMBER(SEARCH(I$2,B3),(J$2,D2)), C3,"")) and get a “Too many Arguments” error Thanks
|