Looking to create function that counts rows only when 2 conditions are met from different rows

I have two rows in question, one containing a list of states, the other containing a list of "types". I am looking to create a function that only counts rows that satisfy 2 specific criteria. For example, only count rows that contain State = Colorado AND type = payment.

To make things more complicated I am referencing the columns from another sheet.

Any help is greatly appreciated.

Find more posts tagged with

Accepted answers

All comments

James,

You can use the COUNTIFS function!

For example: =COUNTIFS(State:State,="Colorado",Type:Type.="payment")

You would use the "Reference Another Sheet" function but make sure you only select the State column in the other sheet for the first reference. And only the Type column for the second reference.

Hope this works out for you!

Best,

Lidiya Shutaya

lidiya@ddbconsultants.ca

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.