count and sum based on a date range

[dunst15]

hi
i would like to do some count and sum calculations based on a date value in a cell on the same row
to be specific the spreadsheet is used to track the production of widgets. each line shows the detail including delivery date and qty of each order. i have a table set up showing the dates of the next 12 fridays. i wish to show the count and sum values of weeks orders due in each of the following 12 weeks.

 

[FDibbins]

You could probably do this with SUMIFS() and COUNTIFS()
=SUMIFS(sum-range, date range, ">=start date", date range, "<= start range+84)

 

[dunst15]

thanks ford.
unfortunately you are dealing with a beginner here......

not working for me it does not seem to recognize j1 and k1 as cell references

=SUMIFS(J9:J2000,K9:K2000,>=j1,K9:K2000,<=k1)

the value of the start date is in J9
the finish date is in K9
the date range is in col K
the data to count is in col J

 

[dunst15]

thanks ford.
unfortunately you are dealing with a beginner here......

not working for me it does not seem to recognize j1 and k1 as cell references

=SUMIFS(J9:J2000,K9:K2000,>=j1,K9:K2000,<=k1)

the value of the start date is in J9
the finish date is in K9
the data range is in col K
the data to count is in col J

 

[dunst15]

ignore the second reply

 

[dunst15]

sorry again. Losing my marbles i think


=SUMIFS(J9:J2000,K9:K2000,>=j1,K9:K2000,<=k1)

the value of the start date is in J1
the finish date is in K1
the date range is in col K
the data to count is in col J

 

[FDibbins]

thanks ford.
unfortunately you are dealing with a beginner here......

not working for me it does not seem to recognize j1 and k1 as cell references

=SUMIFS(J9:J2000,K9:K2000,>=j1,K9:K2000,<=k1)

the value of the start date is in J9
the finish date is in K9
the data range is in col K
the data to count is in col J

You may have missed my use of ""...
=SUMIFS(sum-range, date range, ">=start date", date range, "<= start range+84")

If you use < or = or > with a cell ref, you need to wrap them in quotes....
(assuming the datE is in K and the datA is in J)
=SUMIFS(J9:J2000, K9:K2000,">="&j1,K9:K2000,"<="&k1)