98.7% 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 » Formulas
Formulas
Resolved · High Priority · Version 2003
Thu 8 Oct 2009, 14:43Delegate Kaylea said...
Kaylea has attended:
Excel Advanced course
Formulas
How can I correct this formula?
=SUM(F3-F6:F16)
The result was #VALUE!
Thanks,
Kaylea
Thu 8 Oct 2009, 17:01Trainer Amanda said...
RE: Formulas
Hello Kaylea
Thank you for your question.
Is the result you are after to take the values in F6:F16 and minus them from the value in F3?
Kind regards
Amanda
Fri 9 Oct 2009, 09:46Delegate Kaylea said...
RE: Formulas
yes, thats correct
thanks
Fri 9 Oct 2009, 13:35Trainer Amanda said...
RE: Formulas
Try the following:
=F3-SUM(F6:F16)
Kind regards
Amanda
Fri 16 Oct 2009: 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:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |
