hi
so im looking to could the number of say "D" for deaths given the dates is less than a certain date e.g.
A B
1 1/03/2007 D
2 3/04/2007 L
3 2/06/2008 D
4 3/09/2007 D
5 5/10/2007 n/a
say if i want the date to be less than 31/12/2007 and D
i would use -
=COUNTIFS(B1:B5,"D",A1:A5,A1:A5<C1)
where C1 is 31/12/2007
i should get 2 for the result however the formula gives me a 0..
is it something to do with the formating of the date or is the countif formula i used wrong?
thanks
Bookmarks