CountIf with multiple criteria from different worksheets.

Question

The Current worksheet below is Type1Dem and I need Column D to Count all Text (Field completed) in Column G in the Type1List worksheet that matches Column B in the Type 1 Worksheet and match B4 in the current worksheet Type1Dem.  Any Ideas?.

Answer 1

You want this option?

COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

criteria_range1 (required) - defines the first range to which the first condition (criteria1) shall be applied.

criteria1 (required) - sets the condition in the form of a number, cell reference, text string, expression or another Excel function. The criteria defines which cells shall be counted and can be expressed as 10, "<=32", A6, "sweets".

[criteria_range2, criteria2]… (optional) - these are additional ranges and their associated criteria. You can specify up to 127 range/criteria pairs in your formulas.

or you can use addition of multiple countif function as below:

=COUNTIF(A:A, A2) + COUNTIF(Sheet2!A:A,Sheet1!A2)

Answer 2

I tried to follow this but it does not seem to work. My Columns are the following

I am working in Type1Dem in cell D4.   I want to count the number of records that meet the criteria in Type1Dem B4, on worksheet Type1List Column B:B and also have text in Type1List Column G in the same row.

Answer 3

What is the formula you are using something like below?

=countif(B:B,B4) + Countif(G:G,B4)

Also, You can refer this link for some examples:

https://www.ablebits.com/office-addins-blog/201...

Note: This is a non-Microsoft website. The page appears to be providing accurate, safe information. Watch out for ads on the site that may advertise products frequently classified as a PUP (Potentially Unwanted Products). Thoroughly research any product advertised on the site before you decide to download and install it.