Check if date is between two dates, then sum only those rows
I have tab1 with begin date in column A, end date in column B. Basically they
are weeks, Mon-Sun (e.g. 01/04/2010 and 01/10/2010 in A/B resp.).
Tab2 has data I'd like to count and sum. The transaction date is in column B.
I want to sum tab2 column G (and a few other columns).
Tab2 will be dynamic as I add records to it. Tab1 remains static with each
week comprising one row.
--
streetcar
|