COUNTIF over Range..????

[GUIDO22]

I have successfully used SUMIF to scan a column and using the 'criteria' parameter stipulated a date to sum values for each date entry in the dataset....

Now, I wish to do similar but I wish to count instances where a specific value has been exceeded......

So, consider several rows of data - each row starts with a date......

1/1/14 , 10
1/1/14 , 10
1/1/14 , -20
1/1/14 , -40
1/1/14 , 10
2/1/14 , 10
2/1/14 , 10
2/1/14 , -10
2/1/14 , 10

I wish to be able to determine for each date a count for the number of times each date has a value with criteria similar to "<0" in the second column.... the results for above being:

Result for date 1/1/14 is : 2
Result for date 2/1/14 is : 1

Does anyone have any ideas how to do this please.. thank you!

 

[namliam]

Try using the CountifS function instead

 

[GUIDO22]

Yeah thanks for the pointer, namliam. Done it now.