Stumped with count if's

[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.

 

[hiker95]

Zilla,

Can you supply another screenshot (there are no row numbers or column letters).

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

 

[Zilla]

Sorry

 

[hiker95]

Zilla,

You are posting a picture. This means that if this was a problem where one needed to use your data, anyone trying to help you would have to enter the data manually. That makes no sense and I doubt you'd get any answer.


Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Or, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml

 

[Zilla]

here is a link to the file

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

 

[Zilla]

here is what i have so far but still doesnt seem to work for me.

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

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

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

Y7 Cell
=IF(AND(K7="D",M7="D",O7="D"),1,"")

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

Z7 Cell
=IF(AND(K7="A",M7="A",O7="A"),1,"")

 

[hiker95]

Zilla,

Your link does not work for me.

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php


Or, with Colo's HTML Maker.
http://www.puremis.net/excel/downloads.shtml


Or, if your file does not contain sensitive information, you can upload it to www.box.net and provide a link to your workbook.