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

How can we create dynamic ranges in SUMIFS Formula?

PRASHANT26

New Member
Hi,

I have been trying to define a formula for dynamic ranges in sumifs formula in a way we do for sum formula using Index formula in it but it not working in sumifs.

Pls help.
 
Hi prashant26,

Please try this:
Code:
=SUMIFS(OFFSET(RefCell,,,COUNTA(LookupRange),1),OFFSET(Ref.Criteria1,,,COUNTA(LookupRange),1),Criteria,OFFSET(RefCriteria2,,,COUNTA(LookupRange),1),Criteria)
 

Attachments

  • Dynamic Sumifs.xlsx
    9.1 KB · Views: 36
Hello Prashant,

If you are simply using SUMIFS, then you can use whole column reference like A:A. SUMIFS will ignore non-usable range in calculation
 
Back
Top