Try this:

=Sumproduct(('Sorted Data'!$A$2:$A$564="Apple")*('Sorted
Data'!E$2:E$564="Tree"))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"JB" wrote in message
...
I am trying to use COUNTIF to look at two or more columns. For example,
"Apple" is listed several times in Column A and Tree is listed several
times
in Column E. I want to count all of the occasions where "Apple" in Column
A
and "Tree" in Column E are present together. I wrote the function like
this,
but couldn't get it to return the right answer: =COUNTIF('Sorted
Data'!$A$2:$A$564,"=Apple") + COUNTIF('Sorted Data'!E$2:E$564,"=Tree")

It seems as though the "+" sign is telling it to count both the times
"Apple" is in Column A and when "Tree" is in Column E, so I get the total
number of times "Apple" is in Column A, plus the times "Tree" is in Column
E.
How can I get it to only count the number of times that "Apple" is in
Column
A and "Tree" is in Column E at the same time? This seems like a simple
fix,
but I cannot figure out what to put in there in place of the "+" sign. I
tried "or", but no luck. Thanks.