#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
I found something that seems to work. =IF(AND(ISNUMBER(SEARCH(I$2,B3)),D3=J$2), C3,"") Thank-You
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formula Copy Row 2 Row But Next Column In Formula From Another Tab | TimG | Excel | 3 | 04-16-2018 09:20 PM |
Formula | wheddingsjr | Excel | 4 | 03-23-2017 07:55 AM |
Formula help | Planner18 | Project | 2 | 12-30-2016 03:18 PM |
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula | innkeeper9 | Excel | 2 | 09-13-2016 08:59 PM |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |