Hi,

I'm not sure I fully understand gut how about this

=COUNTIF(B1:B7,"XXX")

Where XXX is the string your looking for. Or if your looking for numbers try

=COUNTIF(B1:B7,1)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Rik_A" wrote:

is there any way to give a result in one cell from the content of other
selected cells.

scenario:
i am trying to create a spreadsheet to work out my current grades for
college. what i am wanting to do is create a function that takes the value
from a selection of cells (ex. B1:B7) and give a result if the content match
a given criteria.
i am looking for something along along the lines of;

cells B1:B7 = x then show result value 1. cells B1:B11 = x then show result
value 2. cells B1:B13 = x then show result 3. (best i can say it as)

my initial through was the IF statement but that failed to give the results.

much appreciated if guidance can be given.