In this post, we will see how to resolve How to count total number of days according to a condition?
Question:I have the following database structure:
DAYS SPEND IN BRASIL
I’m asking this solution because I don’t want to use manual filters from the table.
Thanks for your help
Best Answer:Assuming your data starts in cell A1 you don’t need any query stuff, you can use a plain formula in a new column:
If you have better answer, please add a comment about this, thank you!