LinkBack URL
About LinkBacks
Hi,
I want to lookup a unique reference which are in columns and sumif multiple rows so that it returns one value. I have attached a simple spreadsheet which shows what I am trying to do using xlookup and sumif(s) in one formula.
Many tks
M Jack
Hi,
I want to lookup a unique reference which are in columns and sumif multiple rows so that it returns one value. I have attached a simple spreadsheet which shows what I am trying to do using xlookup and sumif(s) in one formula.
Many tks
M Jack
How aboutFormula:
Please Login or Register to view this content.
Try (old way)
C19
=SUMIFS(INDEX($C$4:$N$12,,MATCH($C$17,$C$3:$N$3,0)),$A$4:$A$12,$A$19,$B$4:$B$12,$B$19)
You should be able to workout C25!
Last edited by JohnTopley; 07-04-2022 at 11:38 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
One way
=SUMIFS(INDEX(C4:N12,,MATCH(C17,C3:N3)),A4:A12,A19,B4:B12,B19)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Cell C19 formula
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks