Terry,

Use SUMPRODCT

=SUMPRODUCT((A1:A100=cond1)*(B1:B100=cond2))

--

HTH

Bob Phillips

"terry freedman" wrote in message
...
Greetings!

is there a way of combining AND and COUNTIF? Basically, I want to
count the number of times each person in a column of people has to
meet a target in a particular month, listed in another column. When I
combine the two I don't get a number, just the word "TRUE".

any ideas?

tia

Terry
==
Terry Freedman
www.ictineducation.org