Sum formula not working

karthik_kaliappan

Board Regular
Joined
Jun 8, 2007
Messages
76
Hi,

I am facing a weird challenge here. I have a column in with I have ifand conditions and the corresponding result is a number. Please see the formula I am below:-

Formula 1 =IF(C16="Yes","5",IF(C16="No","0"))
Formula 2 =IF(AND(C13="Yes",D13="lessthan10mins"),"10",IF(AND(C13="Yes",D13="morethan10mins"),"5",IF(AND(C13="No",D13="NA"),"0")))

Like above a I formule from E12 until E17. I am looking to total the resulting numbers in E18 and the result here is zero. I tried format the cell to number, text....but yet it doesn't work.

Can someone please help me here?

Thanks,
Karthik
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
You need to remove the quotes from around the numbers, otherwise they will be treated as text.
=IF(C16="Yes",5,IF(C16="No",0))
And do the same for the other formula
 
Last edited:
Upvote 0
When you specify number arguments, DO NOT use quotes. =IF(C16="Yes",5,if(C16="No",0)) would work, for example. The way you are doing it, the numbers are text strings not actual numbers, so they have a numerical value of 0. Also, if the only options are "Yes" and "No", you can assume thate the answer is "No" if it isn't "Yes", so don't then need to specify it. If that's the case, the first formula would read =IF(C16="Yes",5,0).
 
Upvote 0
You're welcome & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,223,247
Messages
6,171,007
Members
452,374
Latest member
keccles

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top