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