need to write a formula that counts matches but also meets secondary criterion-CodePudding

Home > Software engineering > need to write a formula that counts matches but also meets secondary criterion

need to write a formula that counts matches but also meets secondary criterion

Time：08-20

I have a sheet that counts matches from column C in "Archive" with "Document list" column A. I have it count total matches just fine. =COUNTIF(Archive!C:C,A:A)

I need to count only the matches where name in "Archive" column H matches "Names" in column A.

Sample sheet

Page link：https//www.codepudding.com/Softwareengineering/517168.html

Prev:How to vertically combine specific columns of a sheet, while producing a category column to each dat

Next:I wrote a php function to add <span></span> to every numeric occurrence in a piece of te

Tags：

google-sheets

Links：
CodePudding