Hi

I am using the below formula to count cells in Sheet1!A2:A5432 which do not
start with 30.

How could I sum these values?

=SUMPRODUCT((LEFT(Sheet1!A2:A5432,2)<"30")*1)

TIA