Stumped with count if's
 

I am stumped with this one I have to do for work.
I have been trying to achieve the following without any luck.
This is what I would like.

In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1

In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5

In cell Y7 if d appears in K7 M7 O7 count as 1

In cell Z7 if A appears in K7 M7 O7 count as 1

I have provided a snap shot of the spreadsheet.

Any help would be appreciated. I guess I have been at it to long today
and my brain is not functioning.

http://imgur.com/jOZKT.jpg

Stumped with count if's
 

In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1
Paste the below formula in W7 Cell
=IF(AND(OR(K7="D",K7="B"),OR(M7="A",M7="B"),OR(O7= "N",O7="B")),1,"")

In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5
Paste the below formula in L7 Cell
=IF(OR(K7="D",K7="A",K7="N"),7,IF(K7="B",7.5,""))

In cell Y7 if d appears in K7 M7 O7 count as 1
Paste the below formula in Y7 Cell
=IF(AND(K7="D",M7="D",O7="D"),1,"")

In cell Z7 if A appears in K7 M7 O7 count as 1
Paste the below formula in Z7 Cell
=IF(AND(K7="A",M7="A",O7="A"),1,"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Zilla" wrote:

I am stumped with this one I have to do for work.
I have been trying to achieve the following without any luck.
This is what I would like.

In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1

In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5

In cell Y7 if d appears in K7 M7 O7 count as 1

In cell Z7 if A appears in K7 M7 O7 count as 1

I have provided a snap shot of the spreadsheet.

Any help would be appreciated. I guess I have been at it to long today
and my brain is not functioning.

http://imgur.com/jOZKT.jpg
.

Stumped with count if's
 

On Nov 30, 11:20*pm, Ms-Exl-Learner wrote:
In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1
Paste the below formula in W7 Cell
=IF(AND(OR(K7="D",K7="B"),OR(M7="A",M7="B"),OR(O7= "N",O7="B")),1,"")

In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5
Paste the below formula in L7 Cell
=IF(OR(K7="D",K7="A",K7="N"),7,IF(K7="B",7.5,""))

In cell Y7 if d appears in K7 M7 O7 count as 1
Paste the below formula in Y7 Cell
=IF(AND(K7="D",M7="D",O7="D"),1,"")

In cell Z7 if A appears in K7 M7 O7 count as 1
Paste the below formula in Z7 Cell
=IF(AND(K7="A",M7="A",O7="A"),1,"")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------

"Zilla" wrote:
I am stumped with this one I have to do for work.
I have been trying to achieve the following without any luck.
This is what I would like.

In cell W7 If cells K7 M7 O7 = the letter d,a,n, or b count as 1

In cell L7 I would like if d a n appear in k7 show as 7 if the letter
b is in K7 show as 7.5

In cell Y7 if d appears in K7 M7 O7 count as 1

In cell Z7 if A appears in K7 M7 O7 count as 1

I have provided a snap shot of the spreadsheet.

Any help would be appreciated. I guess I have been at it to long today
and my brain is not functioning.

http://imgur.com/jOZKT.jpg
.

I should have posted a link to the file.
When I enter the formulas it doesnt seem to provide any data in the
field,

Here is a link to the file without the formulas you have created
entered in.

http://www.megaupload.com/?d=H3WOCXO7