result given from content of selected cells.
Taking your requirements literally, something like:
=(COUNTIF(B1:B7,"x")=ROWS(B1:B7))+(COUNTIF(B8:B11, "x")=ROWS(B8:B11))+(COUNTIF(B12:B13,"x")=ROWS(B12: B13))
should do the trick.
"Rik_A" wrote in message
...
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.
|