M
Mark R.
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!
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!