98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel new functions
Excel new functions
Resolved · Low Priority · Version 2007
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.
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
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.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:##### displaying in ExcelWhen you get a series of hash symbols (####) appearing in some of your cells in a spreadsheet, this can make you think that you've make some kind of mistake. |
