Need total value

Hell everyone

I need your help, I want a total of the below value

HOLD
SOLVED
NO RESPOND

I am trying the IF function but I cannot get the correct formula

For example:

Case 1 = solved
Case 2 = hold
Case 3 = no respond
Case 4 = hold

I want a total of all the status of the cases

Thank you in advance case.xlsx

Look at COUNTIF(s) function(s)

See yellow banner at top of page on how to attach a sample workbook.

Try this:

Please Login or Register  to view this content.

if you prefer if formula :

Please Login or Register  to view this content.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.

Still not marked as solved!