Counting Dates

[BullseyeThor]

Is there a formula that counts a cell with more than one word but only counts this cell if one of the words is specified in a formula.

E.G. I have a range of dates from Apr - Aug but in the same cells are the actual dates (01-Apr-11 and so on to Aug).

I just want a formula that will ignore the numbers and count the words.

I tried the count if and it didn't count it at all.

Thanks in advance.

 

[jmthompson]

Is the data in the cells text or numbers?

 

[BullseyeThor]

the cells contain dd-mmm-yy format so numbers and text yeah.

 

[jmthompson]

Try this test on one of your cells

=ISNumber(pick a cell)
or
=ISTEXT(pick a cell)

 

[BullseyeThor]

That's not what I want sorry.

Example:

Dates

01-aug-11
02-aug-11
05-aug-11
05-jul-11
06-jul-11
06-jun-11

I need a formala that will tell me that out of the highlighted cells with the information above there are 2 instances of July, 3 of August and 1 of June.

Hope that helps more.

 

[jmthompson]

Yes, but we need to know if the actual data in the cells is text or number. If you test a value using one of the formulas I provided, we can proceed from there.

 

[BullseyeThor]

Sorry I understand

The text is false and the numeber is true.

 

[328mike]

That's not what I want sorry.

Example:

Dates

01-aug-11
02-aug-11
05-aug-11
05-jul-11
06-jul-11
06-jun-11

I need a formala that will tell me that out of the highlighted cells with the information above there are 2 instances of July, 3 of August and 1 of June.

Hope that helps more.

Use this formula =MONTH(A2).

Once you have done that filter by month for your aggregated totals.

 

[BullseyeThor]

They don't do what I need

 

[jmthompson]

if you add a new column with 328mike's formula, you can perform a Countif on that column.