COUNTIF a value within a range equals any value in an array/li
Now, say I'm using the first function
=SUMPRODUCT(COUNTIF(ID,Sheet2!C1:C100))
The next column over is a number (elapsed time). How would I change this and
add to it if I want to count all the occurrences of My Site User ID's that
have an elapsed time of 180?
"Harlan Grove" wrote:
"T. Valko" wrote...
Try this:
=SUMPRODUCT(--(ISNUMBER(MATCH(Sheet2!C1:C100,ID,0))))
....
If recalc speed isn't essential,
=SUMPRODUCT(COUNTIF(ID,Sheet2!C1:C100))
should return the same result. If recalc speed is essential, I believe the
array formula
=COUNT(MATCH(Sheet2!C1:C100,ID,0))
would be faster.
|