98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Calculating "IF"
Calculating "IF"
Resolved · High Priority · Version 2007
Thu 5 Jul 2012, 10:56Delegate Audrey said...
Audrey has attended:
Excel Advanced course
Calculating "IF"
I have dont a colum of if formula's what is the best what of totalling these colums or should I say the correct way to get a total
Thu 5 Jul 2012, 14:43Trainer Rodney said...
RE: Calculating "IF"
Hello Audrey,
Hope you enjoyed your Microsoft Excel Advanced course with Best STL.
Thank you for your question regarding the correct way to get a total.
Your question was difficult to read, however, I assume you need to know how to create a formula that produces a total at the end of a column of numbers. The formula would be as follows:
=SUM(A2:A20) assuming that your data numbers started in cell A2 and ended at cell A20
I have attached a file with an example if this helps.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Attached files...
SUM Function.xlsxFri 6 Jul 2012, 19:41Delegate Audrey said...
RE: Calculating "IF"
Hi Rodney
Thank you for working out what I actually wanted and sorry for not making myself clear.
I did the exact formula that you stated about but the total still came back as zero, I even formated the cell thinking it was in the wrong format and it still didnt work. So I don't know if there is a step I am missing.
Thanks
Sat 7 Jul 2012, 12:28
Edited on Sat 7 Jul 2012, 12:29Trainer Rodney said...
RE: Calculating "IF"
Hello Audrey,
I'm sorry you are still having problems with this issue.
Please send your file to me and I will take a look at what step you are missing and get back to you with an answer. My email address is as follows:
rl@stl-training.co.uk
I look forward to your reply...
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Mon 9 Jul 2012, 19:18Delegate Audrey said...
RE: Calculating "IF"
Hi Rodney
Thank you for getting back to me once I am back at work tomorrow I will email the spread sheet to you
Kind Regards
Audrey
Attached files...
Training Spreadsheet.xlsThu 12 Jul 2012, 15:54Trainer Rich said...
RE: Calculating "IF"
Dear Rodney and Audrey,
I received the file to forum@stl-training.co.uk
The email address isn't really monitored, but I'm attaching it to Audrey's post above.
Audrey, there is no upload option at the moment due to security reasons. It is in the pipeline to develop a way forward.
Rich
Thu 12 Jul 2012, 16:45Trainer Rodney said...
RE: Calculating "IF"
Hello Audrey,
I've looked at the cell which you are unable to total. The formula is correct so that would indicate that the data is faulty. The range of data is produced from a formula which uses an IF function. The TRUE part of the formula is "0" and the FALSE part is "£5.25". When entering numbers into the value section of a formula using the IF function do not include inverted commas (""). These are only used for text items. Once you have removed all the inverted commas then the SUM formula works.
Give this a try!
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
Thu 19 Jul 2012: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Viewing two Excel 2010 Workbooks at the same timeDid you know you can view two Excel 2010 workbooks side by side? Very useful when comparing data without constantly having to go back and forth! |
