Question about Microsoft Office Standard for PC

1 Answer

EXCEL FORMULA I HAVE PEOPLE AS NUMBERS LISTED IN COLUMN "E" AND I HAVE THEIR NAMES ELSEWHERE ON THE PAGE. I NEED A RUNNING TOTAL BY EACH NAME HOW MANY TIMES THEIR NUMBERS SHOW UP IN COLUMN "E". I TRIED AN IF STATEMENT BUT IT DIDN'T WORK. AND I HAVE BEEN GUESSING EVER SINCE. PLEASE HELP. THANKS

Posted by on

Ad

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Mentor:

    An expert who has written 3 tips or uploaded 2 video tips.

    Governor:

    An expert whose answer got voted for 20 times.

  • Expert
  • 112 Answers

Try using the formula "sumif". It allows you to sum by category/name. Good luck! D.

Posted on Sep 12, 2007

Ad

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Vlookup for duplicate cell values to display both names in separate cells


Check your formulae for a small error. Use F1 to guide you.

Jul 14, 2017 | The Computers & Internet

2 Answers

How do I set up excel to change the background of a cell as the information within the call changes?


Conditional formating should be able to this. But how is your data organized? (Column headers, Row headers etc.)

Oct 20, 2014 | Microsoft Excel for PC

1 Answer

Sum numbers in a column down until you come to a blank, then start again


Sounds like your issue can be solved readily with a pivot table.
If you give the columns of names a title like "NAME" and the number columns a name like "VALUE". All other columns should contain a unique name.

Then select the entire table, including the labels at the top ensuring that the range extends entirely over the column you need to sum the values of.

In Excel 2013, choose the INSERT menu and select the PIVOT TABLE command.
Insert the Pivot table into a new worksheet.
A new sheet will open with a strange-looking control panel on the right of the window.
Make sure that the box for NAME and VALUE (only) are checked

You will notice that Excel assumes that you want the SUM of the values for each NAME summed. The results are in the leftmost area of the worksheet.

If this works for you, please vote my answer as "helpful".

Sep 03, 2014 | Microsoft Excel for PC

1 Answer

Create a program that will the salary, no of hours work, the deduction, total deduction and net pay.


The easiest way to do this is to use Excel spreadsheet.
This is what you need to do.
Create a label at the top of each column as detailed.
Add a employee to each row under Name of employee
Then against each employee add the data and the formula in the relevant cell under each column.

The first column - Name of the employee
2nd column - salary rate per hour
3rd column - hours worked
4th column - gross pay (formula = salary rate X hours worked)
5th column - tax deduction
6th column - other deductions
7th column - total deductions (formula = tax deduction + other deduction)
8th column - net pay (formula = gross pay - tax - total deductions)

At the last row you can include a total for Gross salary paid, total Tax collected etc.

Once you have setup this spread sheet make a copy of it and save it as a template.
You can then copy this template for each new financial year so you do not have to create a new one each year, you only need to make minor changes for new employees, rates of pay etc.

Another way to make a salary program is to use Access Database. You need more skills to do this, but it can provide greater reporting capabilities.

Mar 24, 2011 | Computers & Internet

1 Answer

My name change request continues to be rejected


You can submit a name change request through the "Name" section of your Account Settings page. Please note that Facebook reviews each name change request that is submitted. Due to the volume of requests they receive, your request may not be processed immediately.

Please note that Facebook account names must adhere to the following authenticity standards:

  • Your full first and last name must be listed. Initials cannot stand in place of your full name. Nicknames can be listed if they are a variation of your first or last name, but only in the format "First Name 'Nickname' Lastname."
  • Your name must be listed using characters from one language only.
  • Your name cannot consist of any titles, symbols, numbers, unusual capitalization, or punctuation.

Impersonating anyone or anything is not permitted. To encourage people to use their real names on Facebook, they limit the number of times names can be changed. Also, if a Facebook representative changes your name for you, this change is considered final and you can't manually change your name afterwards. To list another name you go by, such as a maiden name, please go to the Account Settings page.

Feb 05, 2011 | Facebook Social Network

2 Answers

Panasonic KX-TG1811AL Digital Cordless Phone


sorry, it seems that they have no manual for this model online yet, however, if you go to page 20 of the manual ("http://service.us.panasonic.com/OPERMANPDF/KXTG1032.pdf") that procedure may help. good luck!

Feb 15, 2009 | Panasonic KX-TG1033S Cordless Phone

1 Answer

Input data


If you want to transfer your data into SAS, SPSS, or some other program, follow these guidelines:
The cells in Row 1 should contain the column's eventual data set name. Each name should be a relatively short and unique acronym that clearly identifies the data. It should begin with a letter and contain only letters, numbers, or an underscore ( _ ) where spaces would naturally fall. Avoid using special characters such as $, &, @, in variable names. Since each row represents the values from one subject, the first column(s) should contain one or more variables that give each subject a unique identifier. They become especially important if you need to merge two or more data files.
In Excel, data formats are defined for a range of cells rather than for a complete column. For this reason it is important that each entire column, including cells with missing or uncollected data, have one, and only one, format. Actually, you do not need to format the entire column, only the portion you will eventually use. Highlight that portion and select the appropriate format from the Format/Cells option. Do not select formats that will enter commas, dollar signs, or other visual enhancements. Numeric, text, and date formats (e.g. mm/dd/yy is often a good choice) are probably the only formats you'll ever need.
The "Split" option (under the "Window" pull-down menu) keeps the row of variable names and the columns of identifiers in view, whatever range of cells in the worksheet you may need to review. First place the cursor at the most extreme upper left-hand corner where data entry begins (e.g., the intersection of Row 2 and the column in the upper left-hand corner where data appear) and then select "Split" from this menu. For any row or column of the worksheet you move to, you'll know exactly which variables you are observing (column names) and their associated ID values (rows).
For versions of Excel later than 4.0, one file can contain multiple worksheets. By default, the tabs at the bottom of these sheets are supplied names ("sheet1," "sheet2," etc.). You can change these names by clicking this space with your mouse and entering a new name. Use the same conventions for first-row variable names: use a short acronym of the page contents that begins with a letter, use only letters or numbers, and enter the underscore ( _ ) where a space naturally falls.

Jan 05, 2009 | Sage Instant Accounts 8.0 (013604ug)

1 Answer

Using NOW() in excel formula


That sounds like Excel. You may have to get someone locally to fix that problem.

Jun 10, 2008 | Microsoft Windows XP Professional

1 Answer

Uniden power max 2.4 ghz


I had the same problem but figured it out. For some dumb reason, Caller ID numbers count against your total phonebook memory. So if you just delete all your Caller ID numbers (press the "Caller ID" button and then the "delete" button) then you'll be able to store new numbers in your phonebook.

If I could get my hands on the Uniden engineer that is responsible for this, I'd smack him! :)

May 17, 2008 | Uniden Phone

1 Answer

Sorting within a column


This page covers how to manipulate columns when the data is formatted as "LastName, FirstName MiddleName"... I'm guessing you could just tweak it:
http://www.cpearson.com/excel/FirstLast.htm

This google group goes more in depth on the topic:
http://groups.google.com/group/microsoft.public.excel.misc/browse_frm/thread/49bf87ffdc31a9d3/954544ded2b2f620#954544ded2b2f620

Jan 04, 2008 | Computers & Internet

Not finding what you are looking for?
Microsoft Office Standard for PC Logo

72 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

Ekse

Level 3 Expert

13434 Answers

ThaMp3Doctor
ThaMp3Doctor

Level 3 Expert

8597 Answers

Scoee Scoffer

Level 2 Expert

162 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...