Log In
Register
Home
New Member
December 18, 2019
Offline
Hi,
So i need some help. i'm trying to combine vlookup with this formulae
SUMIF(date range,">"&date,amount)).
So, i have used the sum if to sum up the amounts above a certain defined date.
Then from another sheet, i want to use vlookup to extract particular items and then return the sumif value. combining both has been challenging
| 43466 | |||||
| date | 43466 | 43497 | 43525 | 43556 | 43586 |
| d | 200 | 201 | 202 | 203 | 204 |
| k | 300 | 300 | 300 | 300 | 300 |
| b | 400 | 400 | 400 | 400 | 400 |
| y | 500 | 500 | 500 | 500 | 500 |
| =SUMIF(2:2,">"&E1,3:3) | |||||
| d | =VLOOKUP(G11,C:C,SUMIF(2:2,">"&E1,3:3)) |
August 21, 2019
Offline
deji,
not very clear on your requirement
can you upload a sample of the desire result that you want with the source tables ( the vlookup tables that you want to return to ...)
Rgds
VIP
Trusted Members
June 25, 2016
Offline
Hi deji
You should attach your workbook as it will be clearer. We are unable to see the cell address from your attachment.
Your dates are converted to numbers such as 43466 instead of 01/01/2019 and can be very confusing.
I believe this is what you want, otherwise attach your workbook for us to have a look :
In cell H11 enter
=SUMIF(2:2,">"&E1,INDIRECT(MATCH(G11,C:C,0)&":"&MATCH(G11,C:C,0)))
Good luck
Sunny
1 Guest(s)
