add two different Cells

S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Min+Max from other Tabs 4
Display Zero only in Selected Cells using a formula 8
How to add cells yet neglecting alphabet dats 3
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
function to find which cells add up to a given total? 6
Use SUM to add time format 5
adding summed cells in a conditional sumif 5
Summing one column based on criteria from two other columns 2

Top