I don't have XL07. From your post, I did not get that you wanted to do a
multiple criteria count (which is what I understand countifs is intended). I
thought your request was to count the cells w/apples or grapes, which I think
would be

Countif(...., "*apple")+Countif(....., "*grape")

which returns 5 for me. If this isn't what you want, you should include
additional details about what you want to do, the formula you are currently
using, and what answer you are expecting for the sample data given and
hopefully someone w/XL07 will offer a suggestion.


"dee" wrote:

Hi and thanks for your response.

The problem is when I'm trying to count two separate items in two ranges
using the CountifS function is Excel 2007.

Would you know about that?
Thank you.
--
Thanks!

Dee


"JMB" wrote:

where "apple" is in A6 and your data is in A1:B3, try:

=COUNTIF(A1:B3,"*"&A6)

"dee" wrote:

Hi,

Let's say I have the following in two columns, with a cell that contain the
criteria I wish to count:

red apple orange
pear green applies
peach cherries
red grapes green grapes

apple
grapes

I wish to use Countifs to count the number of apples, no matter the colour,
in both ranges, and grapes, no matter the colour, in both ranges.

I have tried and tried, but seem to always come up with 0.

PLS HLP!

--
Thanks!

Dee