• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Formula Help for finding the count on a certain Condition

Hi..

I have 2 columns in the excel sheet (Column A and Column B)
Column A will contain 4 data (Major NC, Minor NC, Observation/Finding, OFI).
Column B will contain 2 Data (Current Previous).
I want a formula to calculate the number of
Number of:
* Current Major NC
* Current Minor NC
* Current Observation/Finding
* Current OFI
* Previous Major NC
* Previous Minor NC
* Previous Observation/Finding
* Previous OFI

How to do this? Please Guide me.
I have attached the file for Reference
 

Attachments

  • Test.xlsx
    11.9 KB · Views: 9
This is the file where i am trying to find the number of counts

For every Current " Major/Minor/Observation / Finding" a deduction of 5 points shall be done.
For every Previous " Major/Minor/Observation / Finding" a deduction of 8 points shall be done.
No points shall be deducted for OFIs (Current or Previous).

If i get the number of counts. It will be easy for me to calculate the audit score
 

Attachments

  • Test.xlsx
    15.1 KB · Views: 2
Back
Top