I was able to obtain a formula by emailing a contact thru their external
email address, and what they gave does display the results; however, does not
adjust as it should. When I remove one "X" from the cells that fall outside
of the 45 cell section, it should adjust to "B", but doesn't. I wish I could
post the sheet to show a more detailed example, but if you'd like me to email
it, I am happy to send to you.

Here is the formula David provided to me, with alterations for the baseline
numbers:

=IF(COUNTIF(G8:AY13,"X")/111=100%,"A",IF(COUNTIF(G11:AY11,"X")/45=100%,"B",IF(COUNTIF(G11:AY11,"X")/45=100%*80%,"C",IF(COUNTIF(G11:AY11,"X")/45=100%*79.999%,"D"))))

"Questions from cold CT" wrote:

For the result to be "A", all 111 cells have to have an "X". For "B" or "C"
results, there is a separate section within that 111 cells totaling 45. I
didn't have the exact numbers when I typed this in.

"Bob Phillips" wrote:

What does 100% of only a portion mean?

--
__________________________________
HTH

Bob

"Questions from cold CT"
wrote in message ...
I am working on a spreadsheet for my boss that will allow him to track the
progress of our sales team. I've done the formatting, etc, but am now onto
the formulas. I have suggested revisions to the sheet to allow formulas to
work, but he already signed off on phase one (approving said formatting),
so
I kind of built myself inside my house without building a door, so to
speak.
Now, my task is to highlight the areas the sales team is doing well or
needs
improvement. In order to do that, we need the sales team to check off
specific cells. I am figuring using an "X" and having the formula use that
as
reference is feasible. But, here's what I can't figure out. I am not sure
which formula or formulas I should use. I need to be able to return one of
four possible values. If every cell contains an "X", then it should return
"A", if 100% of only a portion of all those cells have an "X", then it
should
return "B", if only 80% of the previous portion are marked, then "C", and
less than 80%, N/A. I was thinking using multiple If statements but dont
know
how to do with the percentages.