• 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 using indexing and matching

G

GODZILLA

New Member
Hello,


What i am looking to do is count the amount of records that meet more than one criteria.


For instance i ahve a column with names in and a column of outcomes.


I want to count when the names column (A) = "GODZILLA" and Outcomes (B) = "Started".


How can i do this?


Thanks
 
=SUMPRODUCT((A:A="GODZILLA")*(B:B="Started"))

or

=COUNTIFS(A:A,"GODZILLA",B:B,"Started")
 
You must log in or register to reply here.
Back
Top