Hey Folks,
I need a formula to put into the table on the right that will sum the values of estimated work and correspond to the name, but also taking into account I only want to sum the values with duplicate "Keys", once.
Thanks
Hey Folks,
I need a formula to put into the table on the right that will sum the values of estimated work and correspond to the name, but also taking into account I only want to sum the values with duplicate "Keys", once.
Thanks
How aboutandFormula:Please Login or Register to view this content.Formula:Please Login or Register to view this content.
Convert the results table into a range.
Use this, copied across and down:
=LET(u,UNIQUE(Table1),SUMPRODUCT((INDEX(u,,2)=$J8)*(INDEX(u,,2+COLUMNS($K8:K8)))))
or:
=LET(u,UNIQUE(Table1),MMULT(--TRANSPOSE(INDEX(u,,2)=$J8),INDEX(u,,2+COLUMNS($K8:K8))))
Last edited by Glenn Kennedy; 06-27-2022 at 08:32 AM.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Cell J8 formula
Formula:Please Login or Register to view this content.
Cell K8 formula copy right
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks