When entering a number into a given range of cells and hitting the enter button, it won't automatically recalculate the new number. the only way to see the new number is by hitting the save button, and the same thing happens when you delete a number in that range. the new total will not show until you hit the save button........very weird and frustrating!!! help, suggestions??? thanks

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

hi,

type in A I001 anb in B I002 and select these two if you are placing your cursor at bottom of B you will find one + symbol instead of cursor. just drag that upto I so you will get 009 .In j type I0010 and in k type 0011 and repeat the same procedure mentioned above upto AX.....You will get answer ...If this will help you, voe for me Thank you...

type in A I001 anb in B I002 and select these two if you are placing your cursor at bottom of B you will find one + symbol instead of cursor. just drag that upto I so you will get 009 .In j type I0010 and in k type 0011 and repeat the same procedure mentioned above upto AX.....You will get answer ...If this will help you, voe for me Thank you...

Oct 29, 2009 | Microsoft Excel for PC

Yes,

That is Select the Cells which you want to SUM and Press**Alt+=**

This will bring the total just below the selected cells.

Thanks

Iqbal

- Select the column. (click on top of the column it will select)
- Right Click and select Format Cells.
- Select
**Currency**in**Category**then press**OK**

That is Select the Cells which you want to SUM and Press

This will bring the total just below the selected cells.

Thanks

Iqbal

Apr 02, 2008 | Computers & Internet

In the cell that you
want the result to appear in, enter the appropriate formula from the following
examples.

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

How to Count the Occurrences of a Number

Use this formula

=SUM(IF(range=number,1,0))

where range is the range that you want to search, and number is the number that you want to count.

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

How to Count the Occurrences of a Text String

Method 1

Use this formula

=SUM(IF(range="text",1,0))

where range is the range that you want to search, and text is the text that you want to find (the text must be enclosed in quotation marks).

NOTE: The above formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Method 2

Use the COUNTIF() function to count the occurrences of a text string. For example, use the formula

=COUNTIF(range,"text")

where range is the range of cells that you are evaluating, and text is the text string that you want to count instances of (note that text must be enclosed in quotation marks).

NOTE: This formula must be entered as an array formula. To enter an array formula, press CTRL+SHIFT+ENTER.

Wildcard characters can be used within the COUNTIF function.

The asterisk character (*) represents more than one character. For example, to count all the cells in the range a1:a10 that contain an "x," you can use the following formula:

=COUNTIF(a1:a10,"*x*")

The question mark character (?) can also be used to represent one wildcard character -- for example, to count all cells in the range whose second character is the letter, such as "ax" or "bx."

=COUNTIF(a1:a10,"?x*")

on Nov 11, 2013 | Microsoft Excel Computers & Internet

It should. What is the error you are getting? What if you click with mouse to next cell?

Mar 29, 2009 | Microsoft Excel for PC

GO TO START

CONTROL PANEL

SECURITY CENTRE

ON AUTOMATIC UPDATES CLICK TURN OFF AUTOMATIC UPDATES.

DONE

ENJOY

HAVE A GOOD DAY

CONTROL PANEL

SECURITY CENTRE

ON AUTOMATIC UPDATES CLICK TURN OFF AUTOMATIC UPDATES.

DONE

ENJOY

HAVE A GOOD DAY

Jan 05, 2009 | Microsoft SQL Server 7.0 (upgrade from...

Jul 15, 2008 | Microsoft Excel for PC

Let's start with the 1st equation. I assume you want to be able to recalculate by changing the number of pages.

Put 65 in cell a1.

360 in b1

In C1, put the formula =a1/b1 that's your book thickness

In D1, put .02 for the cover

In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Put 65 in cell a1.

360 in b1

In C1, put the formula =a1/b1 that's your book thickness

In D1, put .02 for the cover

In E1, put the formula =C1+D1

Now you can change A1, B1,or D1 and the Total thickness gets recalculated automatically. Be careful not to type numbers into C1 or E1, or you lose the formula.

The same for the other equations - a cell for each number ("variable") and another cell for calculations.

Once you've verified the results, then you can get fancy and add titles above each field to make it easy to remember what goes where.

You may need to change the cell format to control the number of decimal places, or thousands commas. Right click on a cell and select format to see the choices you have.

Keep a backup copy of the spreadsheet in case someone (not you, of course) makes a mistake and overwrites the formula cells. You can also look into "protecting" cells to keep them from being changed.

Hope that helps.

Jul 14, 2008 | Computers & Internet

Nope, sorry, although I am truly an expert at Excel formulas, I do not understand what you are trying to end up with in the final cell. We can compare a specified field with two spreadsheets - use named ranges and index/match lookup formulas. But then where you really lose me is in reading "a generic field" to find a match, and then placing what "data from another field" into what "other sheet" - ? See the confusion?

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Best way to compare 2 given parameters would be to use a nested if formula, with index/match combo. Here is a simple Excel example of how such a formula could be structured:

Sample Data (columnar arangement):

A1: Part B1: Code C1: Price D1: Find Part E1: Find Code

A2: x B2: 11 C2: 5.00 D2: y E2: 12

A3: x B3: 12 C3: 6.00 D3: y E3: 11

A4: y B4: 11 C4: 7.00 D4: x E4: 12

A5: y B5: 12 C5: 8.00 D5: x E5: 11

To retrieve the price for part y with code 12 and return the value to cell F2, type the following formula in cell F2:

=INDEX($C$2:$C$5,MATCH(D2,IF($B$2:$B$5=E2,$A$2:$A$5),0))

Press CTRL+SHIFT+ENTER to enter the formula as an array formula. The formula returns the value 8.00.

To take this one step further, with range names, this example will find one value at a specified location which matches a specific row header value and column header value. Let's say the range is home values (Range=HomeVal), Column A of HomeVal contains street addresses,"row headers" (Range=StAddress), and Row 1 contains dates of the various values that are in the body of the table, "column headers" (Range=Dates). To return the specific value from the range HomeVal to another sheet, where A1=address specified and A2=date specified:

=INDEX(HomeVal,(MATCH($A$1,StAddress,0)),(MATCH($A$2,Dates,0)))

Then make sure to press CTRL+SHIFT+ENTER to enter the formula as an array formula - if you only hit enter, these types of formulas will not work properly.

Please post back if you need further help, with more details, otherwise thank you for using and rating FixYa!

Jul 08, 2008 | Microsoft Computers & Internet

You probably want to use the LINEST function for straight lines or LOGEST for exponential curves.

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

In Excel 2007, there are a few tricks. One is to select a range of cells and enter your formula there. If you do not select a range of cells all the variables (coefficentis, R2, errors, etc) will not be dislayed.

The other tricks is one must hit Ctrl+Shift+Enter to display the results.

http://support.microsoft.com/kb/828533 is a link from Microsoft with a detailed explaination. Happy OLS regressing!

kpenguin

May 13, 2008 | Microsoft Excel for PC

Just follow the steps....

- Type "Enter Land in Gundas" in A1
- Type "Equivalent Land in Acres" A2
- Type "=B1/40"
- Now type the number of gundas in B1 example 100
- you will automatically get 2.5 in B2

- Select B2 Cell
- Right Click and goto Format Cell
- Goto Number
- Under Number select Number Catogory
- and then select 2 decimals

Jan 31, 2008 | Computers & Internet

Jan 28, 2016 | Microsoft Excel for PC

22 people viewed this question

Usually answered in minutes!

What version of Excel are you using?

how can possible of data storing power

×