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

Countifs

T

turtel

New Member
Hi All,

Good evening everyone, I have a question about countifs. I have a column with different tests (column B) and a column with different passing criterias (column M) on a worksheet with two tabs called Summary data and January. In the summary data tab, I need to count how many a certain test in the January tab has a passing criteria of let's say "P". I used this formula =COUNTIFS(January!B7:B227,B5,January!M6:M219,"p") and i'm getting a "#VALUE!" message on the cell. I uploaded a sample worksheet. Any help would be appreciated, thanks.
 

Attachments

  • Case log test.xlsx
    275.1 KB · Views: 4
Hi Turtel

Notice how your ranges are varying lengths. That won't work. Square your ranges up and you should be good.

=COUNTIFS(January!$B$7:$B$227,B5,January!$M$7:$M$227,"p")

Take care

Smallman
 
No probs. Just remember to make your formula symmetrical. Need to match ranges and that generally goes for all formula.

Take care

Smallman
 
You must log in or register to reply here.
Back
Top