SUMIF

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

Resolved · Low Priority · Version Standard

SUMIF

Diana has attended:
Excel Advanced course

by - delegate Diana [2 posts] (2008 Feb 13 Wed, 15:54) Reply

what is the quickest way to do a SUMIF for every occurence in a range? how can I check that every occurence has been picked up, and picked up once only?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	2	book now	£215	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
2003	2008 Sep 11 Thu	Southwark	4	book now	£207	£215
2002/XP	2008 Sep 16 Tue	Tooting	0	FULL
2003	2008 Sep 16 Tue	Bayswater	4	book now	£195	£205
2003	2008 Sep 18 Thu	Bloomsbury	2	book now	£215	£215
Full Schedule: See all 137 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: SUMIF

by - trainer Pete platinum contributer [799 posts] (2008 Feb 13 Wed, 19:42) Edited on 2008 Feb 13 Wed, 19:46 Reply

Hi Diana,
Thanks for the post, In answer to your question, consider the syntax, =SUMIF(RANGE TO CHECK, CRITERIA, RANGE TO SUM) this will consider a range of cells, look for a particular item, and then total the corresponding cells in another range. It should normally not be necessary to check, for so long as the criteria has correct matches in the range to check, it will work correctly. I hope that helps, it was good to have you on the course, best regards Pete.

RE: SUMIF

by - trainer Pete platinum contributer [799 posts] (2008 Feb 14 Thu, 09:09) Reply

Hi again Diana, having had time to consider your question again, perhaps you could use the Conditional Sum Wizard, this is an Add In and like Solver needs to be added to your ribbons. The operation is a wizard so follow the steps, it is similar to a SUMIF but enables you to add more variables. I hope that helps best regards Pete.

· A Beginners Guide To Formulas In Excel
· Prepare for your MOS Certification with MS Excel Courses
· Excel Advanced Courses Ease the Frustration of Learning Complex Tasks
· How Excel Training Can Improve Your Company's Sales Process
· How to Create Better Excel Spreadsheets: Part Three

Please browse our web site to find out more about
excel.training.course.london 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