ExcelBanter - Vlookup Sum

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Vlookup Sum (https://www.excelbanter.com/excel-worksheet-functions/27283-vlookup-sum.html)

nfbelo

Vlookup Sum

Hi, I'm having troubles Summing Vlookups. My worksheet has:
A B
05-May-05 2300
06-May-05 6000
07-May-05 4200
08-May-05 9100
09-May-05 2600
10-May-05 1500

Well, I need to SUM amounts of a period like 05 to 09 May using a Vlookup.
I'm trying something like SUM(Vlookup...:Vlookup), but it doesn't work!!
Could someone help me pls. Thanks!!

JE McGimpsey

One way:

=SUMPRODUCT(--(A1:A1000=DATE(2005,05,05),
--(A1:A1000<=DATE(2005,05,09), B1:B1000)

In article ,
nfbelo wrote:

Hi, I'm having troubles Summing Vlookups. My worksheet has:
A B
05-May-05 2300
06-May-05 6000
07-May-05 4200
08-May-05 9100
09-May-05 2600
10-May-05 1500

Well, I need to SUM amounts of a period like 05 to 09 May using a Vlookup.
I'm trying something like SUM(Vlookup...:Vlookup), but it doesn't work!!
Could someone help me pls. Thanks!!

All times are GMT +1. The time now is 04:38 AM.