Hi,
I am trying to determine how many cases raised in 2017 are showing as having a completed status. The data is on a different sheet ("Data"), and the date is in the format of 01/01/1900, but it is only the year detail I need to record.
I have the following 2 formulas, but combining them is proving difficult.
=SUMPRODUCT(1*(YEAR(Data!L2:L600)=2017))
=COUNTIF(Data!N:N,"Completed")
Is there a way to combine the two of them?
Thank you!
Bookmarks