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 » Functions
Functions
Resolved · Low Priority · Version 2003
Wed 29 Jul 2009, 16:56Delegate Eason said...
Thu 30 Jul 2009, 15:35Trainer Amanda said...
RE: functions
Hello Eason
Thank you for your question and welcome to the forum.
Sumif has three parts: the criteria range, the criteria, and the sum range (if this refers to a different range of cells to the criteria range).
I've attached a spreadsheet with a couple of examples so you can see how the function works.
Kind regards
Amanda
Attached files...
sumif examples.xlsThu 6 Aug 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:Shared Conditional FormattingIn a shared workbook, conditional formats applied before the workbook was shared will continue to work; however you cannot modify the existing conditional formats or apply new ones. |
