I have a column for every month (12) and I have criteria that must be met all
months in order for annual points to be awarded. How can I tell cell P5 that
if all cells from D5 to O5 each have an x in them than P5 should equal 50,
but if any one cell does not have the x then P5 should equal 0? Does that
make sense?

I know how to tell it when I'm only looking at one cell: If(D5="x",20,0),
but I need it to look at all cells on that row.

I'd appreciate any help.

if(countif(d5:o5,"x")=12,50,0)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Clara" wrote in message
...
I have a column for every month (12) and I have criteria that must be met
all
months in order for annual points to be awarded. How can I tell cell P5
that
if all cells from D5 to O5 each have an x in them than P5 should equal 50,
but if any one cell does not have the x then P5 should equal 0? Does that
make sense?

I know how to tell it when I'm only looking at one cell: If(D5="x",20,0),
but I need it to look at all cells on that row.

I'd appreciate any help.

=(COUNTIF(D5:O5,"x")=12)*50


"Clara" wrote:

I have a column for every month (12) and I have criteria that must be met all
months in order for annual points to be awarded. How can I tell cell P5 that
if all cells from D5 to O5 each have an x in them than P5 should equal 50,
but if any one cell does not have the x then P5 should equal 0? Does that
make sense?

I know how to tell it when I'm only looking at one cell: If(D5="x",20,0),
but I need it to look at all cells on that row.

I'd appreciate any help.