Hi !!
please need some advice on this formula, i'm receiving 1 as result
What i'm trying to achieve is to Count the occurrences of each number In range EW3:FA38 with each Alphabet
In Range FK3:FK38
Example :
#24 = 2 occurrences with letter A
#29 = 2 occurrences with letter A:
I'm using this formula
=COUNT(IF((FK3:FK38="A")*(AA3:AA38="3"),EW3:FA38))
and i'm getting result 1, i Tried a sum,sumproducts with countif, and still..
=SUMPRODUCT(COUNTIF(EW$3:FA$9,INDEX(FK$3:FK$9,MATCH(AA9,FK$3:FK$9,0),0)))
=SUM(COUNTIFS($EW$3:$FA$38,AA3,$FK$3:$FK$38,"A"))
Thank you !
Bookmarks