Notifications
Clear all
Topic starter
what should I do to count the same character for example "Y" in the same row of different columns in excel?
but don't want to work on ranges suppose if I want to count only Field 1 Field 3 values for John leaving counts for field 2 and 4
Posted : 01/03/2019 2:30 am
You could use something like this:
=SUMPRODUCT(0+(INDEX(B2:E2,1,N(IF(1,{1,4})))="Y"))
which will check the 1st and 4th columns of the range B2:E2 for example.
Posted : 01/03/2019 4:48 am
