Forum Discussion
Re: Help with Sum function
=SUM((TOCOL('All Defects'!I:I,1)<>"Closed")*(TOCOL('All Defects'!I:I,1)<>"Deferred"))
which can be shortened to
=LET(c, TOCOL('All Defects'!I:I,1), SUM((c<>"Closed")*(c<>"Deferred")))
or a COUNTIFS formula:
=COUNTIFS('All Defects'!I:I, "<>", 'All Defects'!I:I, "<>Closed", 'All Defects'!I:I, "<>Deferred")
1 Reply
This worked! Thanks so much.
