Dear users,
Please try and help me solve this long time riddle. I have exhausted all my talent and resources.
Instructions are inside collector workbook.
Solution requested will be in Collector.xlsx workbook in cells G2:J2
My guess it has some combination of if, sumif, sumproduct, greater, less then, equal to, and type nested function that does index and matching the tree type and the date with the data in Samples.xlsx
Note: VLOOK or HLOOK will break due to the Samples workbook having blanks in 2 cells. Need index/match? I have all sort of index and matching formulas but have figured out sumproductif the referenced trees falls between 2 dates in another workbook.
thanks
jr logger
Bookmarks