ExcelBanter - Database

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

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

- - Database (https://www.excelbanter.com/excel-worksheet-functions/55922-database.html)

paulrm906

Database

I have in colmn 1 dates in sequence and in colmn to 2 I have numbers can
someone please tell me a formula for example where I can extract data
from colmn 2 for example from the 1st Oct 05 to the 15th Oct 05. Many
thanks if you could help me. Paul Maynard

--
paulrm906

Roger Govier

Database

Hi Paul

One way
=SUMPRODUCT(--($A$1:$A$100=DATE(2005,10,1)),--($A$1:$A$100<=DATE(2005,10,15)),$B$1:$B$100)
Change ranges to suit, but ensure that they are of equal size.

Regards

Roger Govier

paulrm906 wrote:
I have in colmn 1 dates in sequence and in colmn to 2 I have numbers can
someone please tell me a formula for example where I can extract data
from colmn 2 for example from the 1st Oct 05 to the 15th Oct 05. Many
thanks if you could help me. Paul Maynard

All times are GMT +1. The time now is 02:20 PM.