add two different Cells

[Steved]

Hello from Steved

=IF($A93="MISSED TRIPS TOTAL",SUM(MissedTrips!C36+J36),0)

in cell C36=41
incell J36=13
total = 54

it gives the answer as 3996 What is required please to make it total 54
Thankyou.

 

[Gaurav]

May be

=IF($A93="MISSED TRIPS TOTAL",SUM(MissedTrips!C36,MissedTrips!J36),0)

 

[Steved]

Hello Gaurav

Thankyou.

May be

=IF($A93="MISSED TRIPS TOTAL",SUM(MissedTrips!C36,MissedTrips!J36),0)