LinkBack URL
About LinkBacks
Hi,
I'm trying to use SUMIFS where the column of the table(range) along with the element within that range that will be used to filter are both referenced in two cells that contain drop down lists. Please see attached.
Thank you!
Hi,
I'm trying to use SUMIFS where the column of the table(range) along with the element within that range that will be used to filter are both referenced in two cells that contain drop down lists. Please see attached.
Thank you!
I don't understand, your real request, I guess that's what it means
Cell L7 formula
Formula:
Please Login or Register to view this content.
Last edited by wk9128; 07-04-2023 at 11:08 PM.
More generic, please try in L7 and copy down:Formula:Please Login or Register to view this content.
I will add a new attachment for you to try. TY!
Looking to reference the table column and element within. TY
Please tryIts not a SUMIFS, but it does the job of a SUMIFS.Formula:Please Login or Register to view this content.
EDIT Using SUMIFS in this example is tricky because the first argument of a SUMIFS must be a range (ref). It cannot be an array of any formula. Hence the to SUM
Last edited by HansDouwe; 07-05-2023 at 05:38 PM.
Thank YouOriginally Posted by HansDouwe
Please tryIts not a SUMIFS, but it does the job of a SUMIFS.Formula:Please Login or Register to view this content.
EDIT Using SUMIFS in this example is tricky because the first argument of a SUMIFS must be a range (ref). It cannot be an array of any formula. Hence the to SUM
Cell K7 formula
Formula:Please Login or Register to view this content.
You are Welcome.
Thanks for your feedback, Glad to have helped.
Please consider adding reputation to any helpers you think they deserve.
In that case please click * Add Reputation left below their answers.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks