Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2021, 12:30 PM
14spar15 14spar15 is offline Formula using If and AND Windows 7 64bit Formula using If and AND Office 2010 64bit
Advanced Beginner
Formula using If and AND
 
Join Date: Mar 2011
Posts: 68
14spar15 is on a distinguished road
Default 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
Attached Files
File Type: xlsm Book9.xlsm (10.7 KB, 3 views)
Reply With Quote
  #2  
Old 10-15-2021, 02:39 PM
14spar15 14spar15 is offline Formula using If and AND Windows 7 64bit Formula using If and AND Office 2010 64bit
Advanced Beginner
Formula using If and AND
 
Join Date: Mar 2011
Posts: 68
14spar15 is on a distinguished road
Default

I found something that seems to work. =IF(AND(ISNUMBER(SEARCH(I$2,B3)),D3=J$2), C3,"") Thank-You
Reply With Quote
Reply

Thread Tools
Display Modes


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 using If and AND Formula wheddingsjr Excel 4 03-23-2017 07:55 AM
Formula help Planner18 Project 2 12-30-2016 03:18 PM
Formula using If and AND 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft