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