Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
EXTREMELY IMPORTANT!
My Pivot Table example. "SPREADSHEET" DATE JOB CONTRACTOR 1/1 1 A 1/2 2 B \ A One Cell C / 1/3 3 C when I graph how many time each contractor is used its... "MY UNWANTED GRAPH" contractor A.... 1 time contractor B [] A [] C... 1 time contractor C... 1 time How, if at all possible can I make it... "WHAT I WANT" contractor A... 2 times contractor B... 1 time contractor C... 2 times And whats with the boxes in "contractor B [] A [] C... 1 time" notes: =SUM(IF(ISNUMBER(H3:H43),1,0)) Thats my formula for my pivot table |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot table grouping issues | Excel Discussion (Misc queries) | |||
Pivot Table Count | Excel Discussion (Misc queries) | |||
Count within pivot table | Excel Worksheet Functions | |||
Pivot table range issues from report writer download | Excel Discussion (Misc queries) | |||
Count in Pivot Table | Excel Worksheet Functions |