Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Restructuring: Using Pivot Table w\o the SUM, COUNT etc. Function? | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Count unique values - Pivot Table | Charts and Charting in Excel | |||
pivot table created from another pivot table | Excel Worksheet Functions | |||
Pivot table Data always showing up as "Count" | Excel Discussion (Misc queries) |