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

Some Counts, IFs and Then

F

Frank Bacchus

Member
Hi I have a couple of challenges with counting the occurrences of rows with ands. Here is the example:

=COUNTIFS('CR-TRACKER'!$C$3:$C$300,"APPROVED",$K$3:$K$300,"98")

I am trying to count the number of occurrences where the values in C3 thru C300 is "Approved" and the corresponding row values in K3 thru K300 is "98". I believe that what is happening is that the first condition, when met, the second condition is evaluated in the full range versus the corresponding row.

thanks in advance

frank
 
Your ranges appear correct. The way COUNTIFS works is it checks C3 for "APPROVED" and K3 for "98" and adds 1 to the running count if both are true. Then it checks C4 and K4, C5 and K5, etc.

How are the values in column K stored: numbers, text, etc? "98" tells me that it may not be a number stored as a number, but I can't verify without seeing your data.

Also I notice no sheet reference for $K$3:$K$300. Could that be your issue?
 
You must log in or register to reply here.
Back
Top