Question about Microsoft Office 2003 Basic Edition English (s55-00066) for PC

1 Answer

Setting a Formula

I need to count all fields in a column with an entry, deduct those with an "x" or other symbol, then divide by total fields with an entry, multiply by 100 to get %.

Help

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 7 Answers

You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:
COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

Posted on Nov 24, 2008

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

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

×

Loading...
Loading...

Related Questions:

2 Answers

What is formula to find percentage of females in my workplace?


      To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

      How to do percentages in Excel - Office Blogs

      https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
    Feedback

    How to Calculate Percentages in Excel

    www.excelfunctions.net > Excel-Formulas
    Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

    Excel formula: Get percentage of total ' Exceljet

    https://exceljet.net/formula/get-percentage-of-total
    Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

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

Excel Loan to Value function format


=SUM(Cell1,Cell2,Cell3)/sold_price
Where Cell1, Cell2 and Cell3 are the cell references for the 1st, 2nd and 3rd loan fields and the sold price is the field reference for the cell that has the value for the sold price in it.

Apr 18, 2009 | Microsoft Excel for PC

1 Answer

Count how many times a value appears in a column, based on anothe


Go to the cell you want this total in.
Type this formula:
=SUM(IF(Sheet2!C1:C10="EME",IF(Sheet2!N1:N10=1,1,0)))
make sure you end the formula with CTRL - SHIFT - ENTER which makes it an array formula. If you forget, go back to the cell with this formula and press F2 (to edit the cell) and press CTRL - SHIFT - ENTER to convert it to an array formula (Excel will show a little {...} around the formula).

Dec 21, 2008 | Microsoft Excel for PC

1 Answer

Microsoft excel Formula


create a dummy column (columnC) containing columnA&columnB
use countif at columnD to count the number of observations per combination of columnA and columnB (in particular those with blank entries in columnB).

Sep 15, 2008 | Computers & Internet

1 Answer

Sum of Alternative Columns


Alternative Formula? please explain it.

Jul 31, 2008 | Microsoft Excel for PC

1 Answer

Creating a formula


go to the field with the number of day formula and modify the formula just add to it this *8. The result will be in hrs.
Assuming a holiday uses 8 hrs of pay. It sounds like everyone starts with 25 holiday X 8 hrs or 200 total hours,

Jun 18, 2008 | Computers & Internet

2 Answers

Display calculation result in a previous cell


Look into the =SUMIF function, it sounds like this may be what you are looking for.

Hope this helps!

Apr 09, 2008 | Microsoft Excel for PC

1 Answer

Excel Formula


Yes you can and there are two choices. The simple solution is to label a cell "divide by" and put your number in that filed. Then, by changing only that, your answer (in a separate cell) will be available.
There are more complex solutions -assuming your divide by number had some rhyme and reason that could be put in place but.....try this first and at a later date go back and play. Learning to do that will give you more than a fair amount of Excel expertise....something you may find fairly valuable as you continue on using Excel. FYI...I have developed full blown applications on Excel....it is an excellent tool. Hope this helps....Tango.

Feb 05, 2008 | Microsoft Excel for PC

1 Answer

Calculated field in Excel pivot


Count will only work with numbers. So select another box where you want your number and use this formula: =count(x:x) This should give the count number then you will need to find the difference. In another box, use =sum(x-x). This should give you your difference.


If this helps you, please rate me. Thanks, Patty

Dec 17, 2007 | Computers & Internet

Not finding what you are looking for?
Microsoft Office 2003 Basic Edition English (s55-00066) for PC Logo

102 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

micky dee

Level 3 Expert

2642 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18375 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

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

Answer questions

Manuals & User Guides

Loading...