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

Excel new functions

ResolvedVersion 2007

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

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

Excel new functions

how to nest OR-function into SUMIFS.

Thu 17 Nov 2011, 16:29 Trainer 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

Tue 22 Nov 2011, 09:31 Delegate 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.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Switch on smart tags – Excel 2007

In order to use smart tags, make sure they are turned on, to do this:
1. Click on ‘Microsoft Office‘ button and then click on ‘Excel Options‘.
2. Click on ‘Proofing‘ category and then click on ‘Auto Correct Options‘.
3. In the ‘Auto Correct‘ dialogue box appears, click the ‘Smart Tags‘ Tab.
4. Tick the boxes, next to the Smart Tags you wish to use in Excel

View all Excel hints and tips

Excel new functions

Excel new functions

RE: Excel new functions

RE: Excel new functions

Excel articles

Excel tip:

Switch on smart tags – Excel 2007