| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding 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,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE)) Thankyou |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding formulas
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$1 00,7,FALSE))) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Steved" wrote: 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,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE)) Thankyou |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding formulas
Try one of these:
=IF(COUNTIF(Complaints!A2:A100,B35),SUM(OFFSET(Com plaints!A2,MATCH(B35,Complaints!A2:A100,0)-1,5,,2)),0) =IF(COUNTIF(Complaints!A2:A100,B35),SUM(INDEX(Comp laints!A2:T100,MATCH(B35,Complaints!A2:A100,0),6), INDEX(Complaints!A2:T100,MATCH(B35,Complaints!A2:A 100,0),7)),0) Biff "Steved" wrote in message ... 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,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE)) Thankyou |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding formulas
I Thankyou
"T. Valko" wrote: Try one of these: =IF(COUNTIF(Complaints!A2:A100,B35),SUM(OFFSET(Com plaints!A2,MATCH(B35,Complaints!A2:A100,0)-1,5,,2)),0) =IF(COUNTIF(Complaints!A2:A100,B35),SUM(INDEX(Comp laints!A2:T100,MATCH(B35,Complaints!A2:A100,0),6), INDEX(Complaints!A2:T100,MATCH(B35,Complaints!A2:A 100,0),7)),0) Biff "Steved" wrote in message ... 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,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE)) Thankyou |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding formulas
You're welcome!
Biff "Steved" wrote in message ... I Thankyou "T. Valko" wrote: Try one of these: =IF(COUNTIF(Complaints!A2:A100,B35),SUM(OFFSET(Com plaints!A2,MATCH(B35,Complaints!A2:A100,0)-1,5,,2)),0) =IF(COUNTIF(Complaints!A2:A100,B35),SUM(INDEX(Comp laints!A2:T100,MATCH(B35,Complaints!A2:A100,0),6), INDEX(Complaints!A2:T100,MATCH(B35,Complaints!A2:A 100,0),7)),0) Biff "Steved" wrote in message ... 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,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,6,FAL SE)) =IF(ISNA(VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FA LSE)),0,VLOOKUP($B$35,Complaints!$A$2:$T$100,7,FAL SE)) Thankyou |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding formulas after rows | Excel Discussion (Misc queries) | |||
| Adding formulas after rows | Excel Discussion (Misc queries) | |||
| Adding cells that already have formulas | Excel Discussion (Misc queries) | |||
| Adding text in formulas | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Linear Mode
