SUMIF

The UK's most regular instructor-led training courses.
Training information: excel+course · Excel training london · Microsoft Excel Training London
See also · excel-courses-london · excel courses in london · excel microsoft training

Resolved · Low Priority · Version 2003

SUMIF

Kim has attended:
Excel Intermediate course
Excel Intermediate course

by - delegate Kim [1 post] (2008 Apr 23 Wed, 16:35) Reply

how do you do SUMIF

Version	Date	Location	Places available	Book	Next place rate:
Excel VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 8 Mon + 9 Tue	Bayswater	2	book now	£495	£495
2003	2008 Sep 18 Thu + 19 Fri	Bloomsbury	2	book now	£495	£495
2003	2008 Sep 25 Thu + 26 Fri	Southwark	5	book now	£450	£485
2003	2008 Oct 6 Mon + 7 Tue	Bayswater	4	book now	£475	£485
2007	2008 Oct 13 Mon + 14 Tue	Bayswater	6	book now	£450	£485
2003	2008 Oct 23 Thu + 24 Fri	Southwark	5	book now	£450	£485
Full Schedule: See all 44 Excel VBA course dates. Bookings currently available until 26th November 2009.

RE: SUMIF

by - trainer Pete platinum contributer [799 posts] (2008 Apr 24 Thu, 06:53) Edited on 2008 Apr 24 Thu, 06:55 Reply

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.

· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· Excel Course Tips and Tricks to Liven Up Your Excel Spreadsheets
· How to Create Better Excel Spreadsheets: Part Two
· How to check for and reduce errors in Microsoft Excel
· Excel Macros for the Non-Programmer

Please browse our web site to find out more about
excel+course and other Microsoft training courses.

Excel tip:

Selecting constant values only

If periodically you need to change all your values back to zero, but leave formulas, text and blank cells as they are select the entire worksheet, choose F5 function key, Special and then Constants and choose the appropriate sub-selections. To enter zero in all the selected cells type 0 and then press Ctrl+Enter.

View all Excel hints and tips