Adding formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

T. Valko said:
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
Click to expand...
 
Back
Top