December 18, 2019
So i need some help. i'm trying to combine vlookup with this formulae
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
August 21, 2019
June 25, 2016
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