0
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
3
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.
1Is there a reason you can't just filter on the second column? What happens when you have days in different months? do both 15/8 and 15/9 get listed as 15? For your second question
COUNTIFS
should do the job – cybernetic.nomad – 2018-08-09T17:32:59.8832Also which platform do you want? All three will have a different approach. – Scott Craner – 2018-08-09T17:47:05.990
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. – cukabeka – 2018-08-10T16:28:50.747
The platform should be LibreOffice. If that might not be possible, I'd be willing to switch. Otherwise, I definitely prefer LibreOffice/OpenOffice. – cukabeka – 2018-08-10T16:29:58.750
different months don't occur in this scenario. I'll update the question accordingly. – cukabeka – 2018-08-10T16:30:35.957
updated ans.. hope it helps.. ( : – p._phidot_ – 2018-08-19T03:32:49.520