Vlookup and SUMIF question

[ksun1985]

I have a sheet that contains:

Date, Group Name, Quantity, Customer


I need a function that does VLOOKUP( Group Name & Customer)

then returns the

SUM of (Qty) if within: Today Date & Less 1 month


Im not sure if this is the best way as I have seen others use SUMPRODUCT on similar scenarios.

Any help would be great!

 

[T. Valko]

I have a sheet that contains:

Date, Group Name, Quantity, Customer


I need a function that does VLOOKUP( Group Name & Customer)

then returns the

SUM of (Qty) if within: Today Date & Less 1 month


Im not sure if this is the best way as I have seen others use SUMPRODUCT on similar scenarios.

Any help would be great!

What version of Excel are you using?

 

[ksun1985]

2010

 

[T. Valko]

2010

Try this...

With your data in the range A2:D25...

Use cells to hold the criteria:

• F2: =EDATE(G2,-1)
• G2: =TODAY()
• H2 = some group name
• I2 = some customer

Then:

=SUMIFS(C2:C25,A2:A25,">="&F2,A2:A25,"<="&G2,B2:B25,H2,D2:D25,I2)