Looks like no one’s replied in a while. To start the conversation again, simply ask a new 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

User uploaded file

iMac, OS X Yosemite (10.10.3), Numbers (3.5.3)

Posted on Dec 12, 2017 8:17 AM

Reply
19 replies

Formula to Filter 3 columns & enter data from 3rd

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.