View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HoganD87 HoganD87 is offline
external usenet poster
 
Posts: 22
Default HELP! Customer count issues... Pivot Table disaster

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