COUNTIF Help

  • Thread starter Thread starter David Tunstall
  • Start date Start date
D

David Tunstall

Please help,

I'm not sure even if I should be using the countif
function.

Firstly I have two columns - A) Month and Year of Starting
B) Month and Year of Leaving

Example data would obviously be:

A B
Aug 2000 Apr 2001
Aug 2000
Sep 2000 Apr 2002

On another sheet I have a countif function that gives me a
total of all Aug 2000 Starts (=COUNTIF(A:A,"Aug 2000")
This gives me the correct figure of 2

What I then need to happen is another column to work out,
of those 2 Aug 2000 starts, how many actually have a leave
date. So in this case it would equal 1

Hope this makes sense.
Thanks
David
 
Hi Frank,

It keeps returning 0 for Aug 2000 Starts when it should be
2.

Please help.
Thanks
 
Hi David
how do you store Aug 2000?
- is this a text
- or is this a date formated with the custom format MMM YYYYY

for the latter one try
=SUMPRODUCT((YEAR(A1:A100)=2000")*(MONTH(A1:A100)=8)*(B1:B100<>""))
 
Text
-----Original Message-----
Hi David
how do you store Aug 2000?
- is this a text
- or is this a date formated with the custom format MMM YYYYY

for the latter one try
=SUMPRODUCT((YEAR(A1:A100)=2000")*(MONTH(A1:A100)=8)*
Click to expand...
 
Hi
if it's a text it should work with the first formula if both text
values are identically
 
Back
Top