Max you are awesome! I have to ask was I even close to being on the right
track with the formula I had come up with?

Ok so my next, and I believe last question, is how do I ignore if the cell
is blank?

For example:

H1 would use the formula:
=IF(OR(H6="F",H14="F",H18="F"),"F",IF(AND(H6="P",H 14="P",H18="P"),"P",""))

But say H6=P, H14=P, but H18=NT (or blank). Currently the formula gives a
calue of Blank. But I need it to be able to result a P, as the blank would be
ignored.

The same would happen if H6=F, H14=P, and H18=NT (blank). The result would
be H1=F, the blank in H18 would be ignored.

Does that make sense? I do appreciate your help. I am pretty good at
figuring out formulas in excel but I have been at a loss for this one.

Karen :)

"Max" wrote:

For non contiguous cells, this is the equivalent of the earlier:
=IF(OR(H6="F",H14="F",H18="F"),"F",IF(AND(H6="P",H 14="P",H18="P"),"P",""))

You could also use simple links to "place" all non contiguous cells into a
contiguous range in an empty adjacent part of the sheet, then just use the
earlier COUNTIF checks repointing to the new contiguous range. Or, if the
intervening cells (ie H7:H13 and H15:H17) will not contain anything which
could disturb the required checks, then you could just extend the earlier
range to H6:H18. Joy? hit the YES below
--
Max
Singapore
---
"KL" wrote:
Thanks! Max, That formula works great!
=IF(COUNTIF(H8:H10,"F")0,"F",IF(COUNTIF(H8:H10,"P ")=3,"P",""))

However, now I need a formula for a group of cells (not in a range) that
does the same thing.

For example,

H5 calculates the same thing but is based on cells H6, H14, and H18.

The cells aren't in a range. Is there a way this can be done. When I try to
replace a cell range in this formula with "H6,H14,H18" I get an error.