Stumped with count if's

Z

Zilla

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
 
M

Ms-Exl-Learner

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!
 
Z

Zilla

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!

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top