COUNTIF Statement

Count/Sum Question

Hi I have a field with only 2 values. 0 and -1. I am interested in counting the -1's that occur only if they occur 4 or more times consecutively. Therefore, if the output were 0, 0, -1, -1, 0 the output would be 0. However, if it were 0,0,-1,-1,-1,-1,-1, 0, 0, -1,-1,-1,-1 the sum would be 9. Help...

COUNTIF command using Excel and s comma-delimited file

I saved a comma-delimited file to my excel 2003 worksheet and had a problem using the countif command. It wouldn't recognize the text info. For example, countif(xx:xx,"abc"), it wouldn't recognize the abc cells. Can you help me?