I have large worksheets with (among other things) the following types of data:
Based on the above, what formulas do I use to get the following?:Please Login or Register to view this content.
1. Paid year-to-date thru ShipDate 7/31/08 (result 35.00)
2. Past due year-to-date thru ShipDate 7/31/08 (result 52.00)
3. Future due for orders placed prior to 7/31/08 (result 76.00)
I'm just starting to use the sumproduct and array functions but have gotten thoroughly confused...any help would be greatly appreciated!
Thanks!
k
Bookmarks