Stumped with count if's

Zilla

Board Regular
Joined
Nov 16, 2006
Messages
81
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.

KfVe0.jpg
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

hiker95

Well-known Member
Joined
Apr 8, 2009
Messages
17,649
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

Board Regular
Joined
Nov 16, 2006
Messages
81
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

Well-known Member
Joined
Apr 8, 2009
Messages
17,649

Watch MrExcel Video

Forum statistics

Threads
1,122,193
Messages
5,594,774
Members
413,934
Latest member
austinb

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top