• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sumifs Function

dipak2105

New Member
Dear all,

SUMIFS function work upto criteria 2 but not working more than criteria3,4,5,.....

so where mistake plz. solve


thanks,
 
@dipak


Hi


Firstly welcome to chandoo.org forum, glad you are here


before posting a question please read the 4 Green Sticky Key forum rules


can you give some more details other wise try to upload a sample workbook


Thanks


SP
 
@dipak


Hi


Firstly welcome to Chandoo.org Forum, we are very glad you are here


can you give some more details other wise try to upload a sample workbook


Thanks


SP
 
@dipak


Hi


Firstly welcome to Chandoo.org forums, we are glad you are here


can you give some more details or try to upload a sample workbook


Thanks


SP
 
@dipak


Hi


Firstly welcome to Chandoo.org forums, we are glad you are here


can you give some more details or try to upload a sample workbook


Thanks


SP
 
Hi dipak2105


Welcome to the fourms!!


Consider these two points,


1. Sumifs work with either column or rows, (i think) you can't use it like sumproduct.

2. use equal ranges for sumifs.


Hopefully the problem will resolve.
 
@dipak2105,

Besides ensuring that the ranges are of equal sizes, you will also need to ensure that the arguments you provide as criteria are true references to ranges (and not arrays returned by another function, for example).


Feel free to post your formulas, along with a description of what each argument refers to. That will help someone to help you.


Cheers,

Sajan.
 
Back
Top