Excel 2007 : Count cell with "Yes" and deduct from 100%

**Onenil** · 07-02-2012, 07:16 PM

Hi (sorry about my title - I couldnt think of a suitable one) ;o)

I need to create a basic spreadsheet for work to record data quality. Unfortunately, i've had to take emergency leave so I really need to complete it at home.

The spreadsheet has 25 cells which will be populated with either "yes" or "no". "Yes" signifies that an error has been made. Each error (yes) accounts for 4% and would need to be deducted from 100% to provide a total in the "total" box.

Is this even possible? I've attached a mock up of the relevant part of the spreadsheet so that it, hopefully, makes a little sense. As you've probably guessed, I have zero Excel skills....so please go easy on me.

Any help would be greatly appreciated.

Many thanks

**jeffreybrown** · 07-02-2012, 07:20 PM

Try this in H8

Formula:

Please Login or Register  to view this content.

**vlady** · 07-02-2012, 07:23 PM

somthing like this??

=100-(COUNTIF(C4:G8,"yes")*0.04) - for the first table reference C4:C8

COUNTIF(C4:G8,"yes")*.04 - count the number of "yes" entries then multiply by .04
subtract then from 100

edit: ooopppssss i'm a turtle (slow)

**Onenil** · 07-02-2012, 07:26 PM

Blimey, that was quick - I wasn't expecting a reply for a few days...if at all!!!!! Brilliant, that's exactly what I was after! Thank you both so much!!!

**jeffreybrown** · 07-02-2012, 07:27 PM

You are very welcome. Glad it worked out for you and thanks for the feedback

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save