I need to know a function that will meet criteria in one cell and only count if it also has criteria in another cell. So say i have a column of information, i want it to search the column and count a number (this case 41) and then only count it if in another column there exist the integer(or sometimes number) of 35, 029, FB, etc. I tried the countifs function but it returned !#value error.

Does someone know which direction i can go?