'Excel Count if with index match
I'm trying count number of values from another sheet into column O which has same system name as column B and more than Zero. Could you please let me know the best way to do this?
Solution 1:[1]
I figured the answer. Posting it so someone can use it.
Countif(Index(rangeoflookupvalues,,match(Columnvaluetobematched, rangeofcolumns,0)),">0")
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | cybernetic.nomad |