 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / April 2007Adding formulas
Hello from Steved I would like to please add the 2 below to a cell, What Do I need to do, They are two Cities that I want to be added together to be put in Cell C5. =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)) Thankyou One thought is simply to use SUM(exp1,exp2), viz: =SUM(IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FALSE)),IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)))  SignatureMax Singapore http://savefile.com/projects/236895 xdemechanik --- > Hello from Steved > [quoted text clipped - 5 lines] > =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)) > Thankyou Try one of these: =IF(COUNTIF(Complaints!A2:A100,B35),SUM(OFFSET(Complaints!A2,MATCH(B35,Complaints!A2:A100,0)-1,5,,2)),0) =IF(COUNTIF(Complaints!A2:A100,B35),SUM(INDEX(Complaints!A2:T100,MATCH(B35,Complaints!A2:A100,0),6),INDEX(Complaints!A2:T100,MATCH(B35,Complaints!A2:A100,0),7)),0) Biff > Hello from Steved > [quoted text clipped - 6 lines] > =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)) > Thankyou I Thankyou > Try one of these: > [quoted text clipped - 14 lines] > > =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)) > > Thankyou You're welcome! Biff >I Thankyou > [quoted text clipped - 16 lines] >> > =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FALSE)) >> > Thankyou |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.