Count if formula

[Siddharth Ananthula]

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

 

[slaya_cz]

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

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Siddharth Ananthula]

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

 

[NARAYANK991]

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

 

[Deepak]

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

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"))

 

[Deepak]

One more for cell F2

=SUMPRODUCT((B5:B27={"Inscope","follow up"})*(C5:C27="Azhar"))

 

[NARAYANK991]

Hi Deepak ,

Thanks for the correction.

Narayan

 

[Siddharth Ananthula]

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

 

[Siddharth Ananthula]

Folks, can someone reply. thanks.

 

[NARAYANK991]

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]

How to count coloured font with out VBA

 

[vletm]

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.