TRUE and FALSE don’t work within SUM() November 26, 2023 by Tarik I’ve had success with COUNTIFS over a range where he condition is TRUE =COUNTIF(D2:D51,TRUE)