Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Adding cells with an IF function

0

I have very basic knowledge of Excel so I am hoping that someone can help me with this registration form I am trying to create. I have created an IF function to return $130.00 if there is a name on the registration line. Now I need to add up the total in another cell using each $130 that was returned. When I use the SUM function I only get a $0.00 value returned. I have tried removing the $ from the formula and having it return the value 130, but it still will not add all of the 130's in another cell. What am I doing wrong? Sorry if this sounds really basic, but I really do appreaciate the help!

I am using Windows 10 and Excel 2016

excelformulas-functions
MS Office Version: 2016
posted by: Penguinmommaof2 on Wed Dec 20, 2017 at 1:01 pm
Answer
Discuss

Answers

0

Excel differentiates between text (strings) and numbers. "$130" is a string and therefore not a number. Since it isn't a number it also can't be used in calculations. Therefore the correct formula in J12 (copied down) should insert a number, not a string.

=IF(B12<>"",130,"")
You have correctly used the cell formatting to add the $ sign and the decimals.

Of course, the total in J34 has no conditions. It should just add up the values found in the column above it. 

=SUM(J12:J33)
posted by: Variatus (rep: 4889) on Wed Dec 20, 2017 at 10:17 pm
Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login