Pivot Table - Count If
 

I am trying to figure out Pivot Tables. I think that I somewhat understand
it. My question is can I do a "Count If" in a pivot table.

I have a column that has formulas to calculate wait times. In my pivot
table report I want to count if the wait time is 90 minutes or less by each
physician.

Is this possible?

Pivot Table - Count If
 

Sort the pivot table by physician and run the count function as a subtotal.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Denise" wrote:

I am trying to figure out Pivot Tables. I think that I somewhat understand
it. My question is can I do a "Count If" in a pivot table.

I have a column that has formulas to calculate wait times. In my pivot
table report I want to count if the wait time is 90 minutes or less by each
physician.

Is this possible?

Pivot Table - Count If
 

In the source data, you could add another column to calculate if the
wait time is 90 minutes or less. For example, if your wait time
calculation is in column G:

=IF(G2<=90,1,0)

Then, add the new field to the pivot table's data area, using the Sum
function.

Denise wrote:
I am trying to figure out Pivot Tables. I think that I somewhat understand
it. My question is can I do a "Count If" in a pivot table.

I have a column that has formulas to calculate wait times. In my pivot
table report I want to count if the wait time is 90 minutes or less by each
physician.

Is this possible?




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html