I get "#NAME?" error ;(

"Chin via OfficeKB.com" wrote:

Trish, please try:

=COUNTIFS(A1:A100,"A",B1:B100,"B")

Please advise if that is what you were looking for.


Trish wrote:
I am trying to use the count function where two conditions in different
columns need to be satisfied and having no luck. Basically I want to look in
the first column to see if it's A, then look in 2nd column to see if it's B,
then count it... is that possible?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200904/1