• 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.

Substitution for SUMIFS

P

Pinang

Member
Hi,

I am Pinang, working on reputed IT copmany. I am using Sumifs formula lakhs of data on daily basis, it cause increse in file size and redure calculation speed.

Can anyone let me know the substitute formula for Sumifs?
 
Hi Pinang,

May be you should post a sample file, for the users to have a look of how you had laid your data. Than may be somebody can help you out.

Regards,
 
Pinang

It is highly unlikely that Sumifs is the culprit to your file size

You can also use Sum(if()) or Sumproduct to achieve similar results

Posting the file and showing the issues are the best way for us to specifically help you
 
You must log in or register to reply here.
Back
Top