Hi, can someone please help with a formula please? The top formula works fine. The formula below it is identical apart from it should count cells in the data sheet, column U, where it contains No or is blank. The top formula counts where the cells contains Yes. Can someone please point out why it doesn't not count the No and blank cells? Many thanks
=SUM(COUNTIFS(Data!R:R,RTA!A:A,Data!Q:Q,">1/1/1900"
=SUM(COUNTIFS(Data!R:R,RTA!A:A,Data!Q:Q,">1/1/1900"
,Data!U:U,"Yes
",Data!N:N,"",Data!F:F,{"Clinical Negligence","Financial Mis-Selling","Highway Tripper","Holiday Illness","Industrial Disease","Other PI (Non RTA)","SIPP","Solar","Tripping","Works Accident"})) This works
=SUM(COUNTIFS(Data!R:R,RTA!A:A,Data!Q:Q,">1/1/1900",
Data!U:U,{"No",""}
,Data!N:N,"",Data!F:F,{"Clinical Negligence","Financial Mis-Selling","Highway Tripper","Holiday Illness","Industrial Disease","Other PI (Non RTA)","SIPP","Solar","Tripping","Works Accident"}))
<strike></strike>