W
waxwing
I need a formula to count the number of records meeting a criteria in a
pivot table. Since the column in the pivot table that contains the
data to look at may move when the table is refreshed, I'm a little
stumped. Here's a simple example. Assume we have records of the
number of times we've contact customers by type such as in the
following.
COL A COL B COL C COL D COL E
ROW 1 Count of Contact Type
ROW 2 Customer Phone Mail Fax eMail
ROW 3 John 3 4 1
ROW 4 Pete 2 1 1
ROW 5 Sally 3 3 1 2
ROW 6 Grand Total 8 7 3 3
What I need is something that would tell me there are 2 customers that
received Mail. The formula GETPIVOTDATA("Contact", A1, "Product",
"Mail") would give me 7 no matter where that column was in the table or
how many rows were in it. How can I return the number of rows that
have data for that criteria?
Thanks
- John
pivot table. Since the column in the pivot table that contains the
data to look at may move when the table is refreshed, I'm a little
stumped. Here's a simple example. Assume we have records of the
number of times we've contact customers by type such as in the
following.
COL A COL B COL C COL D COL E
ROW 1 Count of Contact Type
ROW 2 Customer Phone Mail Fax eMail
ROW 3 John 3 4 1
ROW 4 Pete 2 1 1
ROW 5 Sally 3 3 1 2
ROW 6 Grand Total 8 7 3 3
What I need is something that would tell me there are 2 customers that
received Mail. The formula GETPIVOTDATA("Contact", A1, "Product",
"Mail") would give me 7 no matter where that column was in the table or
how many rows were in it. How can I return the number of rows that
have data for that criteria?
Thanks
- John