Discover new time-saving features in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!
=SUMPRODUCT((qryDifference[[#All],[agentno]]=agtno)*(BalanceSheet!G10:G258="Y")* Country_results[agt_amt]+[Difference])
=SUMPRODUCTif((qryDifference[agentno]=Country_results[@agentno])*(qryDifference[Validate Adjustment]="Y")*qryDifference[New Adj Amt])+Country_results[agt_amt])
=IF(qryDifference[agentno]=Country_results[agentno],SUMPRODUCT((qryDifference[agentno]=Country_results[@agentno])*(qryDifference[Validate Adjustment]="Y")*qryDifference[New Adj Amt])+Country_results[agt_amt])
I AM STUMPEDno column that reflect the leads difference (if any).- Not Yet A
then this is NOT possible without VBA..."Not looking for a VBA solution if a function will do the job that's great.
=IF(AND(COUNTIF($B$2:b2,b2)=1,IFERROR(VLOOKUP([agentno],agtno:[Validate Adjustment]],6,FALSE),"")="Y"),[@[agt_amt]]+VLOOKUP([@agentno],agtno:[@Difference],5,FALSE),agtno)
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Modified Max() formula depending on values in adjacent column in Excel | 4 | 33 | |
Excel lookup tables & values | 7 | 25 | |
Copying from excel I am getting extra text | 11 | 39 | |
Excel filter on tab not showing any entries? | 5 | 20 |
Join the community of 500,000 technology professionals and ask your questions.