Forum home » Delegate support and help forum » Microsoft Excel Training and help » SUMIF
|
|
|
The UK's most regular 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. |
SUMIF
Resolved · Low Priority · Version 2003
Reply Wed 23 Apr 2008, 16:35Delegate Kim said...
For upcoming training course dates see: Pricing & availability
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.
|