Hi Edgar
one way
=SUMPRODUCT((LEFT(Sheet1!A2:A5432,2)<"30")*Sheet1 !A2:A5432)
Cheers
JulieD
"Edgar Thoemmes" wrote in message
...
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
|