| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No one gets it... is there a number I can call?
Below is a forum I've posted many times on many websites. I don't believe it
can't be done. I need a count of each person in one cell. but im being told each name must be on its own cell to be counted properly "add a row" "add a cell" I'm hearing... WAY TOO REDUNDANT!! So is there a help line I can call?? 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 "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 | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I get Excel to call my macro for number formatting? | Excel Worksheet Functions | |||
| I'm not sure what you'd call it, but is it possible to do this? | Excel Discussion (Misc queries) | |||
| Call Center Management: How to calculate 'cost per call' | Excel Discussion (Misc queries) | |||
| Number and text format in the same call | New Users to Excel | |||
| Don't know what to call what I need? | Excel Worksheet Functions | |||
Threaded Mode
