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 2003
Wed 23 Apr 2008, 16:35Delegate Kim said...
Thu 24 Apr 2008, 06:53
Edited on Thu 24 Apr 2008, 06:55Trainer Pete said...
RE: SUMIF
Hi Kim, Welcome to the forum, thank you for your post, in answer to your question;
SUMIF adds cells which are specified by criteria which you have set up.
The syntax is; =SUMIF(range to check, criteria, range to sum)
which in terms of a worksheet would be something like =SUMIF(A1:A15,"North",B1:B15) where A1:A5 hold ie the Area Titles, North, South, East and West, where you wish to see a total of figures from the North branch, and these figures are held in the range B1:B15.
Note: if you have a mind to you could name the ranges A1:A15 as "Area" and the range B1:B15 as "Figures" then your formula would be =SUMIF(Area,"North",Figures). The criteria North must be in quotations (") if it is Text. The range Names' do not as once you have created them they are recognised by Excel. I hope that has helped, best regards Pete.
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:Naming and Using ConstantsConstants make calculations easier so worksheets are more easily understood. Constant values also need to be given relevant and memorably names. It is also easier to change the value of a constant. |
