Lookup using two values - like an SQL in the same workbook
One alternative is to use a helper column and CONCATENATE columns A and B
into it and then use the regular formula =COUNTIF(C:C,"AB")
Vaya con Dios,
Chuck, CABGx3
"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?
|