Hello
I am trying to figure out how to calculate the number of time a date appears.


The first image shows the formula I am using which bring a value of 0, and the second image shows the referencing tab.
What am I doing wrong?
Thanks :)
Hello
I am trying to figure out how to calculate the number of time a date appears.


The first image shows the formula I am using which bring a value of 0, and the second image shows the referencing tab.
What am I doing wrong?
Thanks :)
Please select the cell with "2/08/2021" in spreadsheet Y7Q4 - October 21, then check the content shown on Formula Bar.
And then right-click the cell, go to Format cell, check the format.
For better analysis, you may take a screenshot.
Besides, I would suggest you try the formula =COUNTIF('Y7Q4 - October 21'!D:D,'Y7Q4 - October 21'!D154) for a test, as I see the data in cell D154 is "2/08/2021".
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you - when I selected the date cell in the other workbook, it also had a date included. Once removed, the formula worked.
Follow up question though, what would be the correct formula to use if using 2 different criteria's? I thought it would be this:
=COUNTIFS('Y7Q4 August - October 21'!D:D,"2/08/2021",['Y7Q4 August - October 21'!AK:AK,"Complaints"])
The second criteria is to read from the same spreadsheet as the date and use that information alongside the second criteria of complaints.
As in if on "2/08/2021" there were "32 Complaints"
Thanks :)
Yes, Countifis function could be helpful on multi-condition count.
Please try the following formula.=COUNTIFS('Y7Q4 August - October 21'!D:D,"2/08/2021",'Y7Q4 August - October 21'!AK:AK,"Complaints")
4 people are following this question.