Sep 18 2020 02:46 AM - edited Sep 18 2020 03:38 AM
I am using the following formula to count the number of involvements an individual has had whist accessing the service. However, some cases are still open and for those that have no closing date it will not return a value - any suggestions please...
COUNTIFS('F&G'!D:D,B4,'F&G'!L:L,">="&F4,'F&G'!L:L,"<="&G4)
Sep 18 2020 03:19 AM
Sep 18 2020 03:48 AM
Sep 18 2020 04:22 AM
Instead of G4 in formula you may use IF(G4="",TODAY(),G4)
Sep 18 2020 04:33 AM
Thanks, I have tried this but it doesn't work - unless I am misunderstanding what you are telling me to do??
Sep 18 2020 05:39 AM
Hi @Sergei Baklan - I have worked out what you were telling me and yes it works!! Thank you so much I am extremely grateful for your support.
Sep 18 2020 12:59 PM
@DaisyDuke1 , you are welcome, glad to help