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

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

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

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

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