Between 2 Dates lookup and sum help

M

Myrna Larson

I'm not sure I understand what you want to sum, but I"ll assume it's column C, and that you put
the earlier date in K1 and the later date in K2. The following single formula will give you the
total of column C for dates in column A that are between the dates in K1 and K2, inclusive on
both ends.

=SUMIF(A2:A1456,">="&K1,C2:C1456)-SUMIF(A2:A1456,">"&K2,C2:C1456)
 
L

Lou

Hello all.

In columnA I have various dates
In ColumnB I have Code
In ColumnC I have a value
ColumnD I would like to put a formula that would look at the date in columnA
and sum it up if is between 2 dates I put in the formula.

I have 1456 rows of data I need to apply this to. I am using Excel 2002. All
my data starts in A2.

TIA
Lou
 
L

Lou

MY apologies, I didn't explain it clearly, I will past a sample of the table
below, I am trying to back out the items that I used in each fiscal period,
that is why I wanted to choose my to dates to search between. Thank you. Lou

DATE PROD DESCRIPTION QTY COST EXTENDED cost
5/30/2003 ALC003 WINE CHABLIS 5LITER BIB 3 $ 7.35 $
22.05
6/4/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
6/12/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
6/15/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/4/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/6/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/10/2003 ALC003 WINE CHABLIS 5LITER BIB 1 $ 7.35 $
7.35
7/14/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/18/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/21/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/24/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
7/26/2003 ALC003 WINE CHABLIS 5LITER BIB 2 $ 7.35 $
14.70
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top