Excel Formula Countif From Another Sheet. = sumproduct ( countif ( indirect ('&d1:d3&'!b1:b4),excel)) #3 the number of text string “excel” in the same range b1:b4 among three worksheet (sheet1, sheet2 and sheet3) has. The formula below works a treat because it is placed on the same worksheet.
This formula will return the same count as shown in the screenshot above. You can do the following steps: The number of times i've seen someone provide a solution against example data then the op says the formula doesn't work because the actual data is different to.