Example:
I have 3 columns and 11400 rows.
(columns names)homelang, cid, dcid
(data)
98, 101832111, 101832
1, 101832111, 101832
1, 101831666, 101831
98, 101832111, 101832
dcid uses =LEFT(K2, 6) to take off the last 3 digits of cid.
I want to count how many non 98 in homelang there are in dcid 1018321
This is what I tried
{=SUM((H2:H36<>"98")*(K2:K36="1018321"))}
The correct answer for the above data would be 1.
Please help. I am going excel CrAzY.
Bookmarks