LinkBack URL
About LinkBacks
Apologies for the basic question but how do I make a SUMIFS formula dynamic so it will allow for new rows being inserted throughout the sheet?
Many thanks
=SUMIFS($AJ$2:$AJ$2532,$G$2:$G$2532,"Item1",$I$2:$I$2532,"Item2")
Apologies for the basic question but how do I make a SUMIFS formula dynamic so it will allow for new rows being inserted throughout the sheet?
Many thanks=SUMIFS($AJ$2:$AJ$2532,$G$2:$G$2532,"Item1",$I$2:$I$2532,"Item2")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks