=countif formula for dates and values

[MTMann122]

I have a range of cells where the value is either a 1 or a 0. This makes the formula easy to calculate =SUM(A1:A55). Now I want to total up the range of cells but I want to use a date in some cells. I want the formula to return the number of cells with either a "1" or a "DATE 5/31-2011". Of course the date value would be various.

 

[MDCurry]

If I understand correctly you wish to count dates and 1's....or said another way anything greater than zero. If so then this should work:

=COUNTIF(A1:A55,">0")

....to count only the 1's try:
=COUNTIF(A1:A55,"=1")

To count only the dates try:
=COUNTIF(A1:A55,">1")

 

[Aladin Akyurek]

I have a range of cells where the value is either a 1 or a 0. This makes the formula easy to calculate =SUM(A1:A55). Now I want to total up the range of cells but I want to use a date in some cells. I want the formula to return the number of cells with either a "1" or a "DATE 5/31-2011". Of course the date value would be various.

=COUNTIF(A1:A55,1)+COUNTIF(A1:A55,DATE(2011,5,31))

Is this what you want to do?