Need to count all non blank cells in column that meet criteria of two seperaate values

I have tried COUNTIFS and COUNTA together to see if I could get this working.
I have a table that has multiple columns, but I only need to compare 1 column for 2 separate values (High, Severe) and then count non blank cells in a second column.

Column A has values of Severe, High, Medium, Low. Column B has either no value or a document number.

I Need to count all document numbers that are severe or high values in column A. I am having a hard time figuring it out.
thank you.

=SUM(COUNTIFS(A1:A100,{"HIGH","SEVERE"},B1:B100,"<>"))

Adjust the ranges to suit your data.

Is the document number a real number, or is it a text string?

You could try this if they are real numbers.

=SUM(COUNTIFS(A1:A100,{"high","severe"},B1:B100,">0"))

Thank you,
Unfortunately, =SUM(COUNTIFS(A1:A100,{"HIGH","SEVERE"},B1:B100,"<>")), did not work.
It may be because the Document IDs are prefixed by DOC such as DOCxxxxxxx.

Originally Posted by tomcoll67

Thank you,
Unfortunately, =SUM(COUNTIFS(A1:A100,{"HIGH","SEVERE"},B1:B100,"<>")), did not work.
It may be because the Document IDs are prefixed by DOC such as DOCxxxxxxx.

I can't see why that would make a difference. From your original post it would appear the cells in column B are either blank or they're not.
Attaching sample data in a worksheet is always a good idea...

It worked for me, the criteria "<>" is pretty much saying "IS NOT NOTHING"

Can you post a sample book?
Make sure there is just enough data to demonstrate your need. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

I was missing a comma. I apologize and thank you.

Glad you got your solution

Don't forget to mark the thread as SOLVED.

BSB.