Is there a way that i can get excel recognise everytime a name comes up and make it as a number? I am making a spreadsheet on staff and number of sales made. Now i have 1 sheet which records all the sales made and it records the name of the member of staff which made the sale, on a seperate sheet i want excel to notive everytime a staffs name comes up and record the number of sales they have made, so if your name comes up 5 times in sheet 1 then in sheet 2 i want excel to put 5 in the column "number of sales made". How can i do this?
2007-02-23 04:59:25 · 8 answers · asked by vex 4 in Computers & Internet ➔ Software
The function you want is =countif
Basically it works by counting the number of times a given value shows up in a range. You can find more info in the microsoft help section, but this is the one.
2007-02-23 05:08:04 · answer #1 · answered by DT 3 · 3⤊ 0⤋
brandy... has the easiest suggestion. use the SUM function for each sales rep and link that cell with each person's total to the new sheet.
this way, everytime a sale is added, the SUM function will increase the number and that will also change the number in the new sheet.
you will have to make a new master sheet (recording the names and sales) and linked sheet for each time period. if you keep editing the same sheet, you will not be able to see the numbers for certain dates (i.e. the month of October, November, etc.) it will simply total everything.
2007-02-23 13:11:35 · answer #2 · answered by morequestions 5 · 0⤊ 1⤋
If you could construct sheet 1 so that each staff members sales are totaled, then on sheet 2 you could link the cell to the total on page 1.
2007-02-23 13:03:49 · answer #3 · answered by the beet 4 · 0⤊ 2⤋
DT has a point, but didn't show you how,
here it is
IF your column of names in Sheet1 was A, then in Sheet2:
type the name of the member in B3
In C3 paste this
=COUNTIF( Sheet1!A:A, B3)
And it will brings you the number of times that the name in B3 has been found in column A in Sheet1
- You can simply type in the second name in B4 and fill down the cell in C3 into C4 and so on
Trust me, I am the VBAXLMan
2007-02-25 05:07:42 · answer #4 · answered by Anonymous · 0⤊ 0⤋
Convert Numbers to WordsConvert Numbers to Words. In all fairness, I stole this from Microsoft. ... To do this in Microsoft Excel 97, point to Macro on the Tools menu and click ...
xl.barasch.com/cCo11432.htm - 10k - Cached - Similar pages
Display Excel numbers as words
2007-02-23 13:04:26 · answer #5 · answered by god knows and sees else Yahoo 6 · 0⤊ 1⤋
CountIf is the best way to do this. It is clean and does not require you to sort and do subtotals on sheet 1.
Take care,
Troy
2007-02-23 13:21:03 · answer #6 · answered by tiuliucci 6 · 0⤊ 0⤋
Here is a link to all the help you will need to use Excel
The link you need is fifth one down its a 50 min exercise and you should be able to achieve your goal.
http://office.microsoft.com/en-us/training/CR061831141033.aspx
Or you could enrol on the ECDL course at your local college.
2007-02-23 13:21:37 · answer #7 · answered by Anonymous · 0⤊ 1⤋
u should kno...ur the one with the job that you applied for...figure it out buddy...lol..jp...but 4real i dont kno...
2007-02-23 13:02:13 · answer #8 · answered by im so unique 2 · 0⤊ 6⤋