I am looking for a formula that would sum the cells in column A and return the date in column B where it reaches at least 3,000. I have not been able to find anything like this. I tried using SUMIF with VLOOKUP, but haven't been able to find the right combination. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
SUMIF and VLOOKUP
- Thread starter brosello
- Start date
steve the fish
Well-known Member
- Joined
- Oct 20, 2009
- Messages
- 8,894
- Office Version
- 365
- Platform
- Windows
You could try:
=INDEX(B2:B10,MATCH(TRUE,MMULT(--(ROW(A2:A10)>=TRANSPOSE(ROW(A2:A10))),A2:A10+0)>=3000,0))
=INDEX(B2:B10,MATCH(TRUE,MMULT(--(ROW(A2:A10)>=TRANSPOSE(ROW(A2:A10))),A2:A10+0)>=3000,0))
Upvote
0
