"Hall" wrote in message
...
I have a table of data. Elsewhere in the workbook, I want to include a
formula to count all the rows in that table that have a value of "A" in
the
first column and a "B" in the second column. Kind of like

select count(*)
from table
where column1="A" and column2="B"

Is this possible?



Hi

Have a look on this link, which explains a easy way to do your task:

http://www.xldynamic.com/source/xld.SUMPRODUCT.html