countif and AND

[terry freedman]

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

 

[Bob Phillips]

Terry,

Use SUMPRODCT

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

 

[terry freedman]

Terry,

Use SUMPRODCT

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

Bob, that is brilliant, thanks! I knew I had to multiply something,
but didn't know how!

Terry

==
Terry Freedman
www.ictineducation.org