Count in excel

sdc1234

Board Regular
Joined
Mar 17, 2011
Messages
122
Is there a count formula so when I type a # of employees it will show up in a chart...


thx
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

sdc1234

Board Regular
Joined
Mar 17, 2011
Messages
122
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

Board Regular
Joined
Mar 17, 2011
Messages
122

ADVERTISEMENT

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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top