Summing between 2 dates
 

Hi Group!
My first post, to ask a very hard question (or it is for me!!!)
about getting a total of specific objects ("VALVES", etc.) between two
calendar dates. I am putting the totals on Sheet 2 of the workbook,
and the log of the objects ("VALVES") are on Sheet 1. I have 2 boxes
on Sheet 2 to enter dates (C4 start date and C6 end date), with the
"total in" of the specific object on Sheet1 ("VALVES") on Sheet 2 at
E5, and the "total out" between those entered dates, on E11 (which
will be dependent upon a "YES" entered on Sheet1 O2 through O
whatever, if it has been shipped). I know it's probably a SUMPRODUCT
with nested IF's and Date, but I have no clue where to begin. Any
guidance will be greatly appreciated!
Ken

Summing between 2 dates
 

Assuming your dates are on Sheet1 column A, you are probably looking for
something like:

=Sumproduct(--(Sheet1!A2:A100=C4), --(Sheet1!A2:A100<=C6),
--(Sheet1!O2:O100="YES"))

which would count how many items in Sheet1 have a date in Col A that is
between the dates in cells C4 and C6 (inclusive) and have a YES in Sheet1,
Column O.



"Ken" wrote:

Hi Group!
My first post, to ask a very hard question (or it is for me!!!)
about getting a total of specific objects ("VALVES", etc.) between two
calendar dates. I am putting the totals on Sheet 2 of the workbook,
and the log of the objects ("VALVES") are on Sheet 1. I have 2 boxes
on Sheet 2 to enter dates (C4 start date and C6 end date), with the
"total in" of the specific object on Sheet1 ("VALVES") on Sheet 2 at
E5, and the "total out" between those entered dates, on E11 (which
will be dependent upon a "YES" entered on Sheet1 O2 through O
whatever, if it has been shipped). I know it's probably a SUMPRODUCT
with nested IF's and Date, but I have no clue where to begin. Any
guidance will be greatly appreciated!
Ken

Summing between 2 dates
 

On Sep 6, 12:18 am, JMB wrote:
Assuming your dates are on Sheet1 column A, you are probably looking for
something like:

=Sumproduct(--(Sheet1!A2:A100=C4), --(Sheet1!A2:A100<=C6),
--(Sheet1!O2:O100="YES"))

which would count how many items in Sheet1 have a date in Col A that is
between the dates in cells C4 and C6 (inclusive) and have a YES in Sheet1,
Column O.



"Ken" wrote:
Hi Group!
My first post, to ask a very hard question (or it is for me!!!)
about getting a total of specific objects ("VALVES", etc.) between two
calendar dates. I am putting the totals on Sheet 2 of the workbook,
and the log of the objects ("VALVES") are on Sheet 1. I have 2 boxes
on Sheet 2 to enter dates (C4 start date and C6 end date), with the
"total in" of the specific object on Sheet1 ("VALVES") on Sheet 2 at
E5, and the "total out" between those entered dates, on E11 (which
will be dependent upon a "YES" entered on Sheet1 O2 through O
whatever, if it has been shipped). I know it's probably a SUMPRODUCT
with nested IF's and Date, but I have no clue where to begin. Any
guidance will be greatly appreciated!
Ken- Hide quoted text -

- Show quoted text -

Thank you so much!....just transposed some column numbers and your
formula works perfectly! Thank you , thank you!!!!
Ken