Formulas

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

Resolved · Low Priority · Version Standard

Formulas

Stacey has attended:
Excel Intermediate course
Excel Advanced course

by - delegate Stacey [2 posts] (2008 Feb 28 Thu, 15:20) Reply

If i want to create a IFSUM, how can i set the criteria to a range and not just a single cell or name? For example, i have 3000,3001,3002 how can i get them all in one criteria if i want to search for 3000 and 3002?

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: Formulas

by - trainer Mara silver contributer [73 posts] (2008 Mar 8 Sat, 18:53) Reply

Hello Stacey,
I hope you enjoyed your Excel training sessions with us.

In response to your question, SUMIF does not support multiple criteria. However, for a fairly straightforward example as you have given, you may try DSUM instead. The DSUM formula is as follows:

DSUM(database,field,criteria)

The database is the entire range of cells that you are referencing in your formula. The field indicates which column you are summing. Criteria is the range of cells that contains the conditions that you specify. You need to create the criteria ahead of time, in much the same way as you would for an advanced filter.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer