I use Libreoffice. (If Excel or GoogleSpreadsheets would be the only way to get a solution, I would be willing to switch. But the preferred platform is LibreOffice, I'm looking for a solution on this Software).
Here's what I want to achieve, I have a spreadsheet like this:
|Date |Available? |Length | |2/8 9:00 |no |10 |26/8 9:00 |yes |5 |28/8 9:00 |no |2 |29/8 8:00 |yes |5.5 |30/8 9:00 |yes |6 |31/8 9:00 |no |3
Now I want to extract all dates where there is a YES in the "available" column. Different months don't occur in this scenario, so only the day is relevant. What I want to have as a result in some other part of the spreadsheet would be
26, 29, 30
And to make it even a bit more complex, what if I want to count the number of days where length is >5 and available is true? In the above example, this would be
Is that possible? I doodled around with VLOOKUP but have no idea where to start. I guess that Excel would work the same or similar.
I want this to work without the need for the user to filter anything by hand. The idea is to just copy/paste the data and get the result via the formula in another sheet of the file and create an invoice there.