Question: Formula to Filter 3 columns & enter data from 3rd
Have a spreadsheet called Data which has columns with Date, Time & Data. The second spreadsheet called Summary has columns for Date & 4 time periods where the Data is entered.
Am currently doing this using the formula SUMIFS(Data::C,Data::A,A3,Data::B,">10:30",Data::B,"<=15:30").
This works ok if there are just one set of figures per time period but if there are more then it just adds them together.
Is it possible to use a formula that would enter just one set of figures ideally the lowest from a set? ie. there are 3 for the period 20:01 to 24:00 - 8.7, 6.2, 5.7 show 5.7.
Am using Numbers version 4.3.1 (5249) on a iMac (Retina 5K, 27-inch, Late 2014)
Thanks in anticipation
iMac, OS X Yosemite (10.10.3), Numbers (3.5.3)