rizkadiana
New Member
 Joined
 Sep 5, 2020
 Messages
 18
 Office Version

 2016
 Platform

 Windows
Hello All!
I'm trying to create a formula that counts the number of unique dates with two criteria.
I've actually searched within this forum and found a similar question, however because it was casespecific and the conditions differ to mine, the same cannot be applied to mine.
The one with 2 criteria, I've read but because there are no example, I cannot understand the logic, so it is hard to try applying to mine.
This is the picture for context.
The goal is that I want to know how many days, Angelica has eaten the fruit Apple.
Angelica is mentioned 4 times in the dataset. However, the fruit apple is only 3 of them. In addition, the dates has duplicates = meaning the actual times Angelica has eaten Apple is 2 days.
The formula I expected is to show it like this
If tried using =SUM((FREQUENCY ) ; but this only have 1 criteria.
Really appreciated it if anyone can help me with this.
Thank you for all your assistance!
Hope you have a great day!
I'm trying to create a formula that counts the number of unique dates with two criteria.
I've actually searched within this forum and found a similar question, however because it was casespecific and the conditions differ to mine, the same cannot be applied to mine.
The one with 2 criteria, I've read but because there are no example, I cannot understand the logic, so it is hard to try applying to mine.
This is the picture for context.
The goal is that I want to know how many days, Angelica has eaten the fruit Apple.
Angelica is mentioned 4 times in the dataset. However, the fruit apple is only 3 of them. In addition, the dates has duplicates = meaning the actual times Angelica has eaten Apple is 2 days.
The formula I expected is to show it like this
If tried using =SUM((FREQUENCY ) ; but this only have 1 criteria.
Really appreciated it if anyone can help me with this.
Thank you for all your assistance!
Hope you have a great day!