Dynamic sumifs in a table with multiple criteria
Hi All Guys
Here is the situation I am using sumifs to add invoice each data is entered and is dynamic.
At right of sheet sumifs of invoices is working but having totals of invoice based on origin in transpose situation, the first invoice is working but as I moved the formula to the left or downwards, the output results is zero, I have locked the formula but still no results . I noticed that the table also moves in the cells
I am looking for dynamic solution to this.
See annexed
Use actual range address instead of table name. In T2, enter =SUMIFS($L$2:$L$428,$B$2:$B$428,$Q2,$M$2:$M$428,T$1)
Thank you working dynamically when updated data
Using the table nomenclature that you started out with this continues that method
There was an extra space at the end of the Header Origin which I removed.
Enter this in T2 and fill down and across. As you add data to the table the totals automatically change as the ranges are fully dynamic.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Hi
Just check, wonderful.working marvelously
It rocks
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks