will do it, assuming you want the whole column. If you want specific ranges, do
Unfortunately, COUNTIFS() is new to Excel 2007, but there other ways round this...
1) Add an extra column (say column C) and put this formula in:
and sum it to get your answer.
=IF(A1=1, IF(B1="J", 1, 0), 0)
2) Make a pivot table, depending on what you're wanting from the information.
3) put the damned data in Access instead - it's better at doing things like this - and then you can get your answer from a query like
4) If you want something a bit more interesting, like the same count for each different letter, in Access you could do something like this:
SELECT Count(*) AS the_answer FROM mydata WHERE col_A=1 AND col_B='J';
4) or you could do a pivot table in Access too! Not as silly as it sounds, since it's easier to filter and manipulate the pivot table with an Access query anyway.
SELECT col_B as the_letter, Count(*) AS positives
GROUP BY col_B;
For counting all the zeroes and giving overall totals
which will give you a table with each row having the letter, the total number of records, the count for 0 and the count for 1
SELECT col_B AS the_letter, Count(*) as all_results
GROUP BY col_B
Hope this helps,