Count in excel

[sdc1234]

Is there a count formula so when I type a # of employees it will show up in a chart...


thx

 

[Andrew Poulsom]

Please try to be a bit more specific.

 

[sdc1234]

I want to be able to type in a persons name have it update a chart the person will have a # associated with it, also would you be able to answer a merging question for me...

thx

 

[Andrew Poulsom]

Sorry, that's still not specific enough. What do you mean by chart - a cell or a graph? Do you want to lookup the person's name in a table and return the value in the next column? If so in which cell are you typing the name and where is the lookup table?

 

[sdc1234]

it is going to be a pie chart for subcontractors lets say; you have lent out 5000 people and only 50 names r shown up on the roster, I want to have the pie chart show that information by just typing a name in the roster sheet

 

[Andrew Poulsom]

Unless you tell us where the data is on your worksheet and what you want to plot, we won't be able to help you.

 

[sdc1234]

my apologizes, got off track with another project