Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel new functions

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Excel new functions

Resolved · Low Priority · Version 2007

Reply Mon 14 Nov 2011, 16:05Delegate Dmitry said...

Dmitry has attended:
Excel VBA Intro Intermediate course
Excel Advanced course

Excel new functions

how to nest OR-function into SUMIFS.

For upcoming training course dates see: Pricing & availability

Reply Thu 17 Nov 2011, 16:29Trainer Paul said...

RE: Excel new functions

Hi,

To help me understand this, can you please explain why you want to do that and include what result you would want in the sumif cell.

Thanks
Paul

Reply Tue 22 Nov 2011, 09:31Delegate Dmitry said...

RE: Excel new functions

I wanted a formula to look something like this
sumifs(sumrange, creteria range_1,CRITERIA_1(SUBCRITERIA_1 or SUBCRITERIA_2),...............)
I have a few criterias to chose from but i one of them I need to celect two "names" for summaring.

please let me know if I wasn't clear.

thank you.

Excel articles

· Charting Another Dimension With Excel
· Mastering Page Layout In Excel
· Where Is Your Business Heading? Let Excel Help You To Understand!
· Some Mouse Click Tips In Excel
· Radio Buttons And Check Boxes In Excel

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

Excel tip:

Closing Multiple Workbooks quickly

When you have several workbooks open in Excel and want to just close them all at once:

1) Hold down the SHIFT key before selecting the File menu.

2) Once in File menu release SHIFT key and select Close All option.

3) All your files will close. If files require saving Excel will ask if you want to save the changes.

View all Excel hints and tips