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 » Sumif
Sumif
Resolved · Low Priority · Version Standard
Wed 5 Mar 2008, 17:04Delegate Anthony said...
Thu 6 Mar 2008, 11:57Trainer Mark said...
RE: sumif
Hi Anthony
Thank you for the question
As you may recall as of yesterday at the end of the day we covered how to write the sumif formula
here it is again just in case
=sumif(region,"east",sales_99)
to break it down for you goes as follows
you will sum the sales for the east region for the year 1999
If this posting has helped in answering your query then I would request you to mark the posting as Resolved. If, however, it hasn
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:Highlighting a data rangeAttempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own! |
