@@ExcelGoogleSheets yes, I did! I was writing a comment but had to stop and forgot. It definitely solves the arrayformula. I used it today. It's orders of magnitude better than array formula! Thanks! I'm also always waiting for your videos.
@@ExcelGoogleSheets my question not related to this video I want sum range in sum ifs Example- If I have dates in rows city names in columns Rest value is in any number I want to sum numbers on dates criteria & sum range should be matching by headers
Did you answer my question on how to rank, break ties, and award the highest rank to the largest weight and the process would continue until it is broken, in Excel and Google Sheets?
I just found two limitation on my first try! 🤦 1) The returned reference only works on the same sheet. 2) The returned reference does not work on open ranges, so this does not work: XLOOKUP(B13,A2:A9,B2:B9):B
@@ExcelGoogleSheets you'd right about different sheets. I was doing it wrong. But the open ended range really doesn't work. Here's an example: docs.google.com/spreadsheets/d/1iDITuNZ2YiSEzhpwCYshnvmmGHc9yrigbjK_NpccVsA/edit?usp=drivesdk on sheet2
I consider myself an expert in Excel and Google Sheet. But always waiting for your videos because you always present something great.
👍
Sem dúvidas, este e o melhor canal sobre Google Sheets em toda a internet! PARABÉNS!!!
You are great, simple yet effective
Thanks!
Excellent as always!
Thank you!
This is great! It opens lots of possibilities!
Did you check out the MAP video? That should take care of your array problems.
@@ExcelGoogleSheets yes, I did! I was writing a comment but had to stop and forgot. It definitely solves the arrayformula. I used it today. It's orders of magnitude better than array formula! Thanks! I'm also always waiting for your videos.
@@ExcelGoogleSheets
Lambda helper functions didn't take much care from your side!
@@LotfyKozman I'm not sure what you mean. I covered these months ago, very few people watched them.
Another bomb ass video!! Thank you
How can get sum range basis on condition in sumifs
If my header match the take range like A:A
Please suggest
Why do you have to use the whole column? Just start from A2.
@@ExcelGoogleSheets my question not related to this video
I want sum range in sum ifs
Example-
If I have dates in rows
city names in columns
Rest value is in any number
I want to sum numbers on dates criteria & sum range should be matching by headers
Did you answer my question on how to rank, break ties, and award the highest rank to the largest weight and the process would continue until it is broken, in Excel and Google Sheets?
I don't really understand what you're trying to do.
can you do arrayformula and index-match?
yes. czcams.com/video/J1c-N7omkXg/video.html
This is amazing, however, it seems to not work the other way around: =SUM(C5:XLOOKUP("TEST",C5:C,D5:D,,0)) Any suggestions???
works fine for me. your XLOOKUP must not be finding a match.
Didnt vlookup also return a reference?
Yes
I just found two limitation on my first try! 🤦 1) The returned reference only works on the same sheet. 2) The returned reference does not work on open ranges, so this does not work: XLOOKUP(B13,A2:A9,B2:B9):B
this worked for me, even though I have fewer rows
=SUM(XLOOKUP(B13,A2:A9,B2:B9):B1000000)
this works for me as well from different sheet, LOOKUP being the sheet name
=XLOOKUP(LOOKUP!B13,LOOKUP!A2:A9,LOOKUP!B2:B9):LOOKUP!B100
Haven't tried these 2 in Excel.
@@ExcelGoogleSheets you'd right about different sheets. I was doing it wrong. But the open ended range really doesn't work. Here's an example: docs.google.com/spreadsheets/d/1iDITuNZ2YiSEzhpwCYshnvmmGHc9yrigbjK_NpccVsA/edit?usp=drivesdk on sheet2
I didn't say it does, but you can go around it but simply using a very large number, like B1000000