Steveoaktree1977
New Member
- Joined
- May 30, 2020
- Messages
- 7
- Office Version
- 2016
- Platform
- Windows
Hi,
I have created a formula to count the amount of times "closed" appears in column A combined with column H returning a date within a set range.
=COUNTIFS(Data!A:A,"Closed",Data!H:H,">="&J2,Data!H:H,"<="&J3)
What I am getting out is
However source data is this
Any guidance appreciated
Thanks
I have created a formula to count the amount of times "closed" appears in column A combined with column H returning a date within a set range.
=COUNTIFS(Data!A:A,"Closed",Data!H:H,">="&J2,Data!H:H,"<="&J3)
What I am getting out is
However source data is this
Any guidance appreciated
Thanks