software

Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
How can I sum the rows based on a begin and end date?
Example: Begin date is March 10, end date is March 15, I need row 3 summed
for the range of columns that are within the from and to date range.

3/1 3/2 3/3 3/4 etc.
category 1 50.00 5.00 2.00 3.50
category 2 1.00 10.00 .75 .25

I need the formula result to show on another sheet in one column for each
row, I suppose I could just copy the formula down the column.

Thanks!

Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:

=SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))

for period 3rd to 20th march 2006 inclusivelt;b1:w1gt; contain dates
lt;b2:w2gt; contain amounts (for category 1)

Copy down as required

HTH

quot;Michaelquot; wrote:

gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; How can I sum the rows based on a begin and end date?
gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; for the range of columns that are within the from and to date range.
gt;
gt; 3/1 3/2 3/3 3/4 etc.
gt; category 1 50.00 5.00 2.00 3.50
gt; category 2 1.00 10.00 .75 .25
gt;
gt; I need the formula result to show on another sheet in one column for each
gt; row, I suppose I could just copy the formula down the column.
gt;
gt; Thanks!

Hi!

One way:

=SUMPRODUCT((D37=quot;category
3quot;)*(E2:AI2gt;=--quot;3/10/2006quot;)*(E2:AI2lt;=--quot;3/15/2006quot;),E3:AI7)

Biff

quot;Michaelquot; gt; wrote in message
...
gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2,
gt; etc.)
gt; How can I sum the rows based on a begin and end date?
gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; for the range of columns that are within the from and to date range.
gt;
gt; 3/1 3/2 3/3 3/4 etc.
gt; category 1 50.00 5.00 2.00 3.50
gt; category 2 1.00 10.00 .75 .25
gt;
gt; I need the formula result to show on another sheet in one column for each
gt; row, I suppose I could just copy the formula down the column.
gt;
gt; Thanks!
Thanks, I was able to get that to work for one sheet then hit another snag...
There is a worksheet for each month of the year and I am trying to sum on a
13th sheet. I am having trouble creating ranges in the formula that span the
12 monthly worksheets. BTW, the assumption below is correct but it is on
sheet 13. Should I or could I used named ranges to accomplish the
multi-sheet dilemma?

quot;Toppersquot; wrote:

gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:
gt;
gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt;
gt; for period 3rd to 20th march 2006 inclusive
gt;
gt;
gt; lt;b1:w1gt; contain dates
gt; lt;b2:w2gt; contain amounts (for category 1)
gt;
gt; Copy down as required
gt;
gt; HTH
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; gt; How can I sum the rows based on a begin and end date?
gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; gt; for the range of columns that are within the from and to date range.
gt; gt;
gt; gt; 3/1 3/2 3/3 3/4 etc.
gt; gt; category 1 50.00 5.00 2.00 3.50
gt; gt; category 2 1.00 10.00 .75 .25
gt; gt;
gt; gt; I need the formula result to show on another sheet in one column for each
gt; gt; row, I suppose I could just copy the formula down the column.
gt; gt;
gt; gt; Thanks!

Michael,
How do we handle the date ranges for each sheet? It appears
we will need a fomula for each month as the dates will (obviously) be
diferent.

quot;Michaelquot; wrote:

gt; Thanks, I was able to get that to work for one sheet then hit another snag...
gt; There is a worksheet for each month of the year and I am trying to sum on a
gt; 13th sheet. I am having trouble creating ranges in the formula that span the
gt; 12 monthly worksheets. BTW, the assumption below is correct but it is on
gt; sheet 13. Should I or could I used named ranges to accomplish the
gt; multi-sheet dilemma?
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:
gt; gt;
gt; gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt; gt;
gt; gt; for period 3rd to 20th march 2006 inclusive
gt; gt;
gt; gt;
gt; gt; lt;b1:w1gt; contain dates
gt; gt; lt;b2:w2gt; contain amounts (for category 1)
gt; gt;
gt; gt; Copy down as required
gt; gt;
gt; gt; HTH
gt; gt;
gt; gt; quot;Michaelquot; wrote:
gt; gt;
gt; gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; gt; gt; How can I sum the rows based on a begin and end date?
gt; gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; gt; gt; for the range of columns that are within the from and to date range.
gt; gt; gt;
gt; gt; gt; 3/1 3/2 3/3 3/4 etc.
gt; gt; gt; category 1 50.00 5.00 2.00 3.50
gt; gt; gt; category 2 1.00 10.00 .75 .25
gt; gt; gt;
gt; gt; gt; I need the formula result to show on another sheet in one column for each
gt; gt; gt; row, I suppose I could just copy the formula down the column.
gt; gt; gt;
gt; gt; gt; Thanks!

There are 12 sheets, one for each month. Row one has the days of the month,
column A contains the categories and to the right of the categories and under
each day of the month values are entered throughout the month for each day.

Sheet one row one contains the dates 1/1/06 through 1/31/06
Sheet two row one contains the dates 2/1/06 through 2/28/06
etc. through sheet twelve. The sheets are named jan, feb, mar, etc.
Sheet 13 would summarize the category values based on a from and to date
range which may cross over more than one sheet but not three.

quot;Toppersquot; wrote:

gt; Michael,
gt; How do we handle the date ranges for each sheet? It appears
gt; we will need a fomula for each month as the dates will (obviously) be
gt; diferent.
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; Thanks, I was able to get that to work for one sheet then hit another snag...
gt; gt; There is a worksheet for each month of the year and I am trying to sum on a
gt; gt; 13th sheet. I am having trouble creating ranges in the formula that span the
gt; gt; 12 monthly worksheets. BTW, the assumption below is correct but it is on
gt; gt; sheet 13. Should I or could I used named ranges to accomplish the
gt; gt; multi-sheet dilemma?
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:
gt; gt; gt;
gt; gt; gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt; gt; gt;
gt; gt; gt; for period 3rd to 20th march 2006 inclusive
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; lt;b1:w1gt; contain dates
gt; gt; gt; lt;b2:w2gt; contain amounts (for category 1)
gt; gt; gt;
gt; gt; gt; Copy down as required
gt; gt; gt;
gt; gt; gt; HTH
gt; gt; gt;
gt; gt; gt; quot;Michaelquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; gt; gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; gt; gt; gt; How can I sum the rows based on a begin and end date?
gt; gt; gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; gt; gt; gt; for the range of columns that are within the from and to date range.
gt; gt; gt; gt;
gt; gt; gt; gt; 3/1 3/2 3/3 3/4 etc.
gt; gt; gt; gt; category 1 50.00 5.00 2.00 3.50
gt; gt; gt; gt; category 2 1.00 10.00 .75 .25
gt; gt; gt; gt;
gt; gt; gt; gt; I need the formula result to show on another sheet in one column for each
gt; gt; gt; gt; row, I suppose I could just copy the formula down the column.
gt; gt; gt; gt;
gt; gt; gt; gt; Thanks!

As an example, for dates 13th Feb to 20th March inclusive this would provide
a (relatively) simple solution:

=SUMPRODUCT(--(Feb!$B$1:$W$1gt;=DATE(2006,2,13)),--(Feb1!$B$1:$W$1lt;=DATE(2006,2,28)),--(Feb!B2:W2))
=SUMPRODUCT(--(Mar!$B$1:$W$1gt;=DATE(2006,3,1)),--(Mar!$B$1:$W$1lt;=DATE(2006,3,20)),--(Mar!B2:W2))

There may be a more quot;sophisticatedquot; formula but I wouldn't know how to
construct it.

Is this exceptable?

quot;Michaelquot; wrote:

gt; There are 12 sheets, one for each month. Row one has the days of the month,
gt; column A contains the categories and to the right of the categories and under
gt; each day of the month values are entered throughout the month for each day.
gt;
gt; Sheet one row one contains the dates 1/1/06 through 1/31/06
gt; Sheet two row one contains the dates 2/1/06 through 2/28/06
gt; etc. through sheet twelve. The sheets are named jan, feb, mar, etc.
gt; Sheet 13 would summarize the category values based on a from and to date
gt; range which may cross over more than one sheet but not three.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Michael,
gt; gt; How do we handle the date ranges for each sheet? It appears
gt; gt; we will need a fomula for each month as the dates will (obviously) be
gt; gt; diferent.
gt; gt;
gt; gt; quot;Michaelquot; wrote:
gt; gt;
gt; gt; gt; Thanks, I was able to get that to work for one sheet then hit another snag...
gt; gt; gt; There is a worksheet for each month of the year and I am trying to sum on a
gt; gt; gt; 13th sheet. I am having trouble creating ranges in the formula that span the
gt; gt; gt; 12 monthly worksheets. BTW, the assumption below is correct but it is on
gt; gt; gt; sheet 13. Should I or could I used named ranges to accomplish the
gt; gt; gt; multi-sheet dilemma?
gt; gt; gt;
gt; gt; gt; quot;Toppersquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:
gt; gt; gt; gt;
gt; gt; gt; gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt; gt; gt; gt;
gt; gt; gt; gt; for period 3rd to 20th march 2006 inclusive
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; lt;b1:w1gt; contain dates
gt; gt; gt; gt; lt;b2:w2gt; contain amounts (for category 1)
gt; gt; gt; gt;
gt; gt; gt; gt; Copy down as required
gt; gt; gt; gt;
gt; gt; gt; gt; HTH
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Michaelquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; gt; gt; gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; gt; gt; gt; gt; How can I sum the rows based on a begin and end date?
gt; gt; gt; gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; gt; gt; gt; gt; for the range of columns that are within the from and to date range.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; 3/1 3/2 3/3 3/4 etc.
gt; gt; gt; gt; gt; category 1 50.00 5.00 2.00 3.50
gt; gt; gt; gt; gt; category 2 1.00 10.00 .75 .25
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; I need the formula result to show on another sheet in one column for each
gt; gt; gt; gt; gt; row, I suppose I could just copy the formula down the column.
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Thanks!

I will set it up that way and test it, thanks!

quot;Toppersquot; wrote:

gt; As an example, for dates 13th Feb to 20th March inclusive this would provide
gt; a (relatively) simple solution:
gt;
gt; =SUMPRODUCT(--(Feb!$B$1:$W$1gt;=DATE(2006,2,13)),--(Feb1!$B$1:$W$1lt;=DATE(2006,2,28)),--(Feb!B2:W2))
gt; =SUMPRODUCT(--(Mar!$B$1:$W$1gt;=DATE(2006,3,1)),--(Mar!$B$1:$W$1lt;=DATE(2006,3,20)),--(Mar!B2:W2))
gt;
gt; There may be a more quot;sophisticatedquot; formula but I wouldn't know how to
gt; construct it.
gt;
gt; Is this exceptable?
gt;
gt; quot;Michaelquot; wrote:
gt;
gt; gt; There are 12 sheets, one for each month. Row one has the days of the month,
gt; gt; column A contains the categories and to the right of the categories and under
gt; gt; each day of the month values are entered throughout the month for each day.
gt; gt;
gt; gt; Sheet one row one contains the dates 1/1/06 through 1/31/06
gt; gt; Sheet two row one contains the dates 2/1/06 through 2/28/06
gt; gt; etc. through sheet twelve. The sheets are named jan, feb, mar, etc.
gt; gt; Sheet 13 would summarize the category values based on a from and to date
gt; gt; range which may cross over more than one sheet but not three.
gt; gt;
gt; gt; quot;Toppersquot; wrote:
gt; gt;
gt; gt; gt; Michael,
gt; gt; gt; How do we handle the date ranges for each sheet? It appears
gt; gt; gt; we will need a fomula for each month as the dates will (obviously) be
gt; gt; gt; diferent.
gt; gt; gt;
gt; gt; gt; quot;Michaelquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Thanks, I was able to get that to work for one sheet then hit another snag...
gt; gt; gt; gt; There is a worksheet for each month of the year and I am trying to sum on a
gt; gt; gt; gt; 13th sheet. I am having trouble creating ranges in the formula that span the
gt; gt; gt; gt; 12 monthly worksheets. BTW, the assumption below is correct but it is on
gt; gt; gt; gt; sheet 13. Should I or could I used named ranges to accomplish the
gt; gt; gt; gt; multi-sheet dilemma?
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Toppersquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in column B put:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; for period 3rd to 20th march 2006 inclusive
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; lt;b1:w1gt; contain dates
gt; gt; gt; gt; gt; lt;b2:w2gt; contain amounts (for category 1)
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; Copy down as required
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; HTH
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot;Michaelquot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2, etc), rows
gt; gt; gt; gt; gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo day 2, etc.)
gt; gt; gt; gt; gt; gt; How can I sum the rows based on a begin and end date?
gt; gt; gt; gt; gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3 summed
gt; gt; gt; gt; gt; gt; for the range of columns that are within the from and to date range.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; 3/1 3/2 3/3 3/4 etc.
gt; gt; gt; gt; gt; gt; category 1 50.00 5.00 2.00 3.50
gt; gt; gt; gt; gt; gt; category 2 1.00 10.00 .75 .25
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I need the formula result to show on another sheet in one column for each
gt; gt; gt; gt; gt; gt; row, I suppose I could just copy the formula down the column.
gt; gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; Thanks!

With your sheet named Jan - Dec the dates in question lower date in A1 and
upper date in B1 on the summary sheet

=SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;{quot;Janquot;;quot;Febquot;;quot;Marquot;; quot;Aprquot;;quot;Mayquot;;quot;Junquot;;quot;Julquot;;quot;Augquot;;quot;Sepquot;;quot;Octquot;;quot;Novquot;;quot;D ecquot;}amp;quot;'!1:1quot;),quot;gt;=quot;amp;A1,INDIRECT(quot;'quot;amp;{quot;Janquot;;quot;Febquot;;quot;M arquot;;quot;Aprquot;;quot;Mayquot;;quot;Junquot;;quot;Julquot;;quot;Augquot;;quot;Sepquot;;quot;Octquot;;quot;Nov quot;;quot;Decquot;}amp;quot;'!3:3quot;)))-SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;{quot;Janquot;;quot;Febquot;;quot;Marquot;;quot; Aprquot;;quot;Mayquot;;quot;Junquot;;quot;Julquot;;quot;Augquot;;quot;Sepquot;;quot;Octquot;;quot;Novquot;;quot;De cquot;}amp;quot;'!1:1quot;),quot;gt;quot;amp;B1,INDIRECT(quot;'quot;amp;{quot;Janquot;;quot;Febquot;;quot;Mar quot;;quot;Aprquot;;quot;Mayquot;;quot;Junquot;;quot;Julquot;;quot;Augquot;;quot;Sepquot;;quot;Octquot;;quot;Novquot;; quot;Decquot;}amp;quot;'!3:3quot;)))

if the sheet names are in the range J1:J12

=SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!1:1quot;),quot;gt;= quot;amp;A1,INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!3:3quot;)))-SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!1:1quot;),quot;gt;quot;amp; B1,INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!3:3quot;)))

both formulas sum row 3, change the 3:3 to another row for another category,
you could let a formula do that as well, assume you have a list of
categories in the summary sheet called MyList and you put the category in C1

=SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!1:1quot;),quot;gt;= quot;amp;A1,INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!quot;amp;MATCH(C1,MyList,0)amp;quot; :quot;amp;MATCH(C1,MyList,0))))-SUMPRODUCT(SUMIF(INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!1:1quot;),quot;gt;quot;amp; B1,INDIRECT(quot;'quot;amp;J1:J12amp;quot;'!quot;amp;MATCH(C1,MyList,0)amp;quot;:quot; amp;MATCH(C1,MyList,0))))
-

Regards,

Peo Sjoblom
quot;Michaelquot; gt; wrote in message
...
gt; There are 12 sheets, one for each month. Row one has the days of the
gt; month,
gt; column A contains the categories and to the right of the categories and
gt; under
gt; each day of the month values are entered throughout the month for each
gt; day.
gt;
gt; Sheet one row one contains the dates 1/1/06 through 1/31/06
gt; Sheet two row one contains the dates 2/1/06 through 2/28/06
gt; etc. through sheet twelve. The sheets are named jan, feb, mar, etc.
gt; Sheet 13 would summarize the category values based on a from and to date
gt; range which may cross over more than one sheet but not three.
gt;
gt; quot;Toppersquot; wrote:
gt;
gt;gt; Michael,
gt;gt; How do we handle the date ranges for each sheet? It
gt;gt; appears
gt;gt; we will need a fomula for each month as the dates will (obviously) be
gt;gt; diferent.
gt;gt;
gt;gt; quot;Michaelquot; wrote:
gt;gt;
gt;gt; gt; Thanks, I was able to get that to work for one sheet then hit another
gt;gt; gt; snag...
gt;gt; gt; There is a worksheet for each month of the year and I am trying to sum
gt;gt; gt; on a
gt;gt; gt; 13th sheet. I am having trouble creating ranges in the formula that
gt;gt; gt; span the
gt;gt; gt; 12 monthly worksheets. BTW, the assumption below is correct but it is
gt;gt; gt; on
gt;gt; gt; sheet 13. Should I or could I used named ranges to accomplish the
gt;gt; gt; multi-sheet dilemma?
gt;gt; gt;
gt;gt; gt; quot;Toppersquot; wrote:
gt;gt; gt;
gt;gt; gt; gt; Assuming Sheet2 has Category1, Category2 etc in column A, then in
gt;gt; gt; gt; column B put:
gt;gt; gt; gt;
gt;gt; gt; gt; =SUMPRODUCT(--(Sheet1!$B$1:$W$1gt;=DATE(2006,3,3)),--(Sheet1!$B$1:$W$1lt;=DATE(2006,3,20)),--(Sheet1!B2:W2))
gt;gt; gt; gt;
gt;gt; gt; gt; for period 3rd to 20th march 2006 inclusive
gt;gt; gt; gt;
gt;gt; gt; gt;
gt;gt; gt; gt; lt;b1:w1gt; contain dates
gt;gt; gt; gt; lt;b2:w2gt; contain amounts (for category 1)
gt;gt; gt; gt;
gt;gt; gt; gt; Copy down as required
gt;gt; gt; gt;
gt;gt; gt; gt; HTH
gt;gt; gt; gt;
gt;gt; gt; gt; quot;Michaelquot; wrote:
gt;gt; gt; gt;
gt;gt; gt; gt; gt; Columns represent days of the month (E2 is day 1, F2 is day 2,
gt;gt; gt; gt; gt; etc), rows
gt;gt; gt; gt; gt; represent dollar amounts (E3 is $ amt for day one, F3 is $ amt fo
gt;gt; gt; gt; gt; day 2, etc.)
gt;gt; gt; gt; gt; How can I sum the rows based on a begin and end date?
gt;gt; gt; gt; gt; Example: Begin date is March 10, end date is March 15, I need row 3
gt;gt; gt; gt; gt; summed
gt;gt; gt; gt; gt; for the range of columns that are within the from and to date
gt;gt; gt; gt; gt; range.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; 3/1 3/2 3/3 3/4 etc.
gt;gt; gt; gt; gt; category 1 50.00 5.00 2.00 3.50
gt;gt; gt; gt; gt; category 2 1.00 10.00 .75 .25
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; I need the formula result to show on another sheet in one column
gt;gt; gt; gt; gt; for each
gt;gt; gt; gt; gt; row, I suppose I could just copy the formula down the column.
gt;gt; gt; gt; gt;
gt;gt; gt; gt; gt; Thanks!