Of course SUMPRODUCT works fine here but the normal approach would be to use COUNTIF, e.g.Originally Posted by pjoaquin
=IF(COUNTIF(A1:E10,"Mike"),1,"")
Of course SUMPRODUCT works fine here but the normal approach would be to use COUNTIF, e.g.Originally Posted by pjoaquin
=IF(COUNTIF(A1:E10,"Mike"),1,"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks