Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > SUMIIFS function

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

SUMIIFS function

Reply to Message Icon

Name: Solika
Date: October 13, 2009 at 03:59:02 Pacific
OS: Excel 2007
Product: Microsoft Office 2007 professional (academic)
Subcategory: Microsoft Office
Comment:

Hello,

I'm trying to make a function using SUMIIFS function with 21 criterias but the below error message appreas

*more arguments have been specified for this function that are allowed in the current file format

Can anyone help with this?



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: October 13, 2009 at 04:36:36 Pacific
Reply:

=SUMIF() functions can not be nested.

What is it your trying to do?

MIKE

http://www.skeptic.com/


0

Response Number 2
Name: Solika
Date: October 13, 2009 at 06:12:57 Pacific
Reply:

Hi

It's SUMIFS function not SUMIF


0

Response Number 3
Name: Humar
Date: October 13, 2009 at 06:28:08 Pacific
Reply:

Hi,

Please post the formula that you have written, so that we can see what is causing the error.

(SUMIFS is new to Excel 2007)

Regards


0

Response Number 4
Name: Mike (by mmcconaghy)
Date: October 13, 2009 at 06:40:14 Pacific
Reply:

OK, I stand corrected.

=SUMIFS() functions can not be nested.

What is it your trying to do?

MIKE

http://www.skeptic.com/


0

Response Number 5
Name: jon_k
Date: October 13, 2009 at 07:30:35 Pacific
Reply:

sounds like you might have the spreadsheet saved as a .xls rather than a .xlsx

Make sure you save the workbook as a 2007 file format and you should be fine.

SUMIFS can have up to 127 pairs of data so should work with 21 criteria no problems.


0

Related Posts

See More



Response Number 6
Name: Solika
Date: October 13, 2009 at 07:49:36 Pacific
Reply:

hello

The file is saved as .xlsx
i'll make some changes in the formula and i'll contact u again if i failed

thank you all for your help


0

Response Number 7
Name: Mike (by mmcconaghy)
Date: October 13, 2009 at 08:07:46 Pacific
Reply:

Since you seem reluctant to give us any info, the only other thing I can suggest is to be aware that each criteria_range must contain the same number of rows and columns as the sum_range.

MIKE

http://www.skeptic.com/


0

Response Number 8
Name: Solika
Date: October 13, 2009 at 23:39:25 Pacific
Reply:

i'm not reluctant to give u any info
i just noticed that my formula will not give any value even without the error msg, i made a contradictory criteria that will sum up 0 at the end because the criteria will never match.
the formula must be made as the sum of 27 SUMIF formulas not SUMIFS with 27 rang and criteria
i'll just try the other option
thanks


0

Sponsored Link
Ads by Google
Reply to Message Icon

IF Statement Saving file to word from ...


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links
Ads by Google


Results for: SUMIIFS function
Access 2000 CUMIPMT Function www.computing.net/answers/office/access-2000-cumipmt-function/611.html

Office Help function not working www.computing.net/answers/office/office-help-function-not-working/3625.html

GoalSeek function in Excell ??? www.computing.net/answers/office/goalseek-function-in-excell-/1510.html