|
|
Also, I forgot to mention this earlier, the formula you presented only works if the value is in the first column. If it isn't I get a zero, when I know the value does occur in other rows. How can I get the formula to count across the entire row from every column, not just starting from the first one? SUMPRODUCT seems to be the key, but am I doing something wrong?
|