• 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.

Count if formula

Status
Not open for further replies.
S

Siddharth Ananthula

New Member
Hello Folks

Request to help me. I am trying to apply filters within my countif formula.

Attached is the sheet. In red, I have my requirements/questions.

Thanks in advance.

Sid
 

Attachments

  • Question for Chandoo.xlsx
    9.6 KB · Views: 1
Hi Sid

just use COUNTIFS function like that
COUNTIFS($B$2:$B$24;"Inscope";$C$2:$C$24;"Azhar")
This should resolve your problem.

Cheers
slaya_cz
 
Narayan and Slaya. thank you.

However, I have added one more condition for follow up required, Its in the same column, How may I use multiple conditions in the same column?

Kindly help.

Sid
 

Attachments

  • Question for Chandoo - solution.xlsx
    9.8 KB · Views: 1
Hi ,

The formula used is what is known as an array formula ; to enter this formula , you have to press the combination of 3 keys CTRL SHIFT ENTER.

Narayan
 

Attachments

  • Question for Chandoo - solution.xlsx
    9.9 KB · Views: 3
NARAYANK991 said:
Hi ,

The formula used is what is known as an array formula ; to enter this formula , you have to press the combination of 3 keys CTRL SHIFT ENTER.

Narayan
Click to expand...

Hi,

I think here CSE is not required as formula will produced the same output without array too..

=SUM(COUNTIFS(B5:B27,{"Inscope","follow up"},C5:C27,"Azhar"))
 
Guys, thank you so much for the help. The formula is indeed working great.
Just wanted one more tip. I am using this formula in a different tab of the spreadsheet. The actual values are in the adjacent tab. once I am saving this formula and pressing enter, I am seeing a wierd dotted lines randomly in the sheet. These are disturbing the view.
These are not gridlines as I have tried to get rid of them. Can you please tell why I am seeing it and what I should do in order to get rid of them.
Thanks,
Sid
 
Hi ,

It would help if you can upload the problem file.

It may be to do with your Error Checking settings , which can be turned ON or OFF from Excel Options.

Narayan
 

Vishnu kumar​

You should open a new thread for Your own case.
... it'll be smoother for You to upload a sample Excel-file to show You case.
This few Years old thread is closed now.
 
Status
Not open for further replies.
Back
Top