Adding formulas

[Steved]

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

 

[Max]

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)))

 

[T. Valko]

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

 

[Steved]

I 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

 

[T. Valko]

You're welcome!

Biff

I Thankyou