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!