Best Junk File Cleaner: COUNTIF FUNCTION WITH MULTIPLE VALUES

Friday, September 23, 2016

COUNTIF FUNCTION WITH MULTIPLE VALUES

Good Day dears,

I was looking for a formula that could help me in the following but I could find one.

I have this excel sheet
COLUMN1 COLUMN2

A
EK

B
EK

A

A
EK

BN

A
EK

OFF

A
EK

B

OFF

BN
EK

OFF

A
EK

BN
EK

OFF

A
EK

A

B
EK

B

I need a formula that counts EK + B OR BN and give me the ruselts

what I am trying yo say is that ...
when "EK" in the second column come along with "B" or "BN" in the first column to be counted ...
when "EK" is come with "A" or "OFF" not to be counted

I have tried this but it gave me an error =COUNTIFS(M2:M94,"EK",C2:C94,"B" OR "BN")
I have also tried this but it gave me the count of every cells separately =COUNTIF(M2:M94,"EK)+COUNTIF(C2:C94,"B")+COUNTIF(C2:C94,"BN")

this results I expected from the furmula for the above sample is 4

Thanks a lot in advance

Solutions to the Problem COUNTIF FUNCTION WITH MULTIPLE VALUES

Download SmartPCFixer for Free Now

=COUNTIFS(M2:M94,"EK",C2:C94,"B")+COUNTIFS(M2:M94,"EK",C2:C94,"BN")

Run CHKDSK to Fix COUNTIF FUNCTION WITH MULTIPLE VALUES

Go to the Start button.
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

NOTE: You might receive an error message that states:

"Access denied as you do not have significant privileges. You have to invoke this utility in elevated mode."

If you receive the above error message, it means you are not logged into you computer as an Administrator. If that's the case, follow these steps to run the command prompt in elevated mode:

Go to theStart button.
Go to "All Programs > Accessories" and right click on "Command Prompt".
Select "Run as Administrator".
In the Search box, type "cmd" (without quotes) and press Enter.
At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
Reboot your computer.

Recommended Method to Fix the Problem: COUNTIF FUNCTION WITH MULTIPLE VALUES:

How to Fix COUNTIF FUNCTION WITH MULTIPLE VALUES with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.