Forum

Notifications
Clear all

Combining Vlookup and SUMIF(date_range,">"&Date,Amount)

3 Posts
3 Users
0 Reactions
118 Views
(@deon80)
Posts: 1
New Member
Topic starter
 

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))
 
Posted : 19/12/2019 12:09 am
(@bluesky63)
Posts: 162
Estimable Member
 

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

 
Posted : 19/12/2019 1:38 am
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 19/12/2019 8:11 pm
Share: