Summing all cells containing the letter K
Thank you very much for helping.
But can you tell me, what does the two minus before (--ISNUMBER... do?
Jan
"Teethless mama" skrev i melding
...
=SUMPRODUCT(--ISNUMBER(SEARCH("K",A1:F1)))
"Jan T." wrote:
Hi.
I want to count all cells in a range that contains the letter K.
RON BLAIR KASPER HULK FRONT KIM
The example here would return 3 because 3 cells are containing a name
that
has K in it.
I think I should put functions like SUMPRODUCT AND ISNUMBER AND MATCH,
but how do I put theese together?
Thanks in advance.
Mvh
Jan
|