Between 2 Dates lookup and sum help

  • Thread starter Thread starter Myrna Larson
  • Start date Start date
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)
 
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
 
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
 
Back
Top