View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lise Lise is offline
external usenet poster
 
Posts: 102
Default countif with two criteria one a column of dates?

I have two columns and am entering the following formula
=COUNTIF($B$2:$B$436,"**-AU-****")+COUNTIF($A$2:$A$436,"**/**/2005")

The wildcards in the B column are used to show that I only want to count the
cells in that column that have AU in the middle.

I then want to break it down futher by counting how many times 2005 appears
in the corresponding cell of column A

This is not working - where am I going wrong please?
--
Thanks as always

Lise