You could try this:

=COUNTIF(D25:D35,"apples")+COUNTIF(D50:D75,"apples ")

Hope this helps.

Pete

On Jan 13, 12:27*am, jolineachi
wrote:
I'm trying to do something similar. *I need to count the number of apples in
column D. *But i only need to count the ones in rows 25-35 and rows 50-75. *
I've tried countif, sumif, and sumproduct. *Is there a way to do this?



"Bob Phillips" wrote:
=COUNTIF(A1:A100,"*@*")

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joan NYC" wrote in message
...
Aha... Sumproduct is not a function I ever tried

I have a column of text. *Some cells contain the character "@" with a
space
preceding the rest of text in the cell. *I realize the @ could be
considered
an operator so it is preceded with an apostrophe to designate text. *I
want
to sum the cells that have the "@"

Thanks

"David Biddulph" wrote:

You'll need to be a bit clearer as to what you're trying to do. *If
COUNTIF
or SUMIF doesn't do the job, you may want to try SUMPRODUCT.
--
David Biddulph

"Joan NYC" wrote in message
...
I have been trying to calculate a column of Text in order to sum
contents
by
certain criteria

I have tried Count, CoutA and CountIF and cannot be able to get
anything
to
work.

Am I barking up the wrong tree? :) *Can this be done?

Thanks much.- Hide quoted text -

- Show quoted text -