Thanks for your reply. Exact formula that I'm using now:

=COUNTIF(AW$6:AW$10000,AW7)

This formula counts AW7=Column B, but does so regardless of the value in
Column A (see above post).

"Mark R." wrote:

I'm using a COUNTIF formula as a helper column next to a pivot table. One of
the columns (call it column A) of the pivot table has two possible values,
and I want the COUNTIF formula to only count the data in column B if column A
has a particular value.
That is, I'd like to define the range of COUNTIF to be all rows where Column
A = MyValue. VLOOKUP in the range field doesn't seem to work, and I'm kinda
out of ideas. Any suggestions?

Thanks!