Counting a cell as integer if it meets criteria in two cells

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?

Well, that sounds confusing ...

Perhaps if you attached a sample workbook (the FAQ describes how to) that would make a bit more sense.

Pete

Nevermind i figured it out. The ranges were different sizes and it was causing an issue. Thanks though!