Simple Formula Question - Urgently need your help!!

hi,

I have the following simple formula: =A61*E61

I need to know how I can highlight a block of cells - Let's say row
62-86 and have that formula update itself to reflect each row number
(A column & E column remain throughout only the numbers of the row
change)

Hope that made sense. I know it's a simple proceedure I just can'
remember how to do it. Your help would be greatly appreciated as I'
really up against a deadline.

Thanks!! :

--
Message posted from http://www.ExcelForum.com

0
1/13/2004 2:35:19 PM
excel 39879 articles. 2 followers. Follow

1 Replies
411 Views

Similar Articles

[PageSpeed] 38

just copy the formula for all rows. Excel will change the formula
accordingly
Frank

0
frank.kabel (11126)
1/13/2004 2:56:42 PM
Reply:

Similar Artilces:

Excel formulas #21
I am creating a spreadsheet that tracks our current staff across the country. Is there a way to create a formula that counts from two different fields. For example I want the total number of people if Column B reads "ATLANTA" and column F reads "ACTIVE" I was thinking I could use COUNTIF somehow....but can't quite figure it out One way =SUMPRODUCT(--(B2:B100="ATLANTA"),--(F2:F100="ACTIVE")) you could replace the criteria with cell references so it be easier to change criteria, also note that unlike countif you can't use the whole column...

Mell Install Question
We have MELL Installed on a Web Server. It is working fine and we have several modules up and running and will be adding more and more.. When we first installed eLearning, we said 'NO' to the SQL Server peice of the install. Now we'de like to have it log to SQL Server but am not sure how to go about doing this. reun the install? uninstall and reinstall?? I know there must be a way to implement SQL Server without having to reinstall the whole thing !!!! Can anyone help? ...

Simple graph
I have a chart with zip codes and a population rate. ZIP RATE 80001 2.34 80002 1.23 80003 1.23 I want to make a chart that has the rate on the x axis and the number of times that rate occurs on the y axis. | | | * | | * |_________________________________ | | 1.23 2.34 Thank you. I will assume the ZIP and RATE stuff is in A1:B200 (labels in row 1) Label in G1 to read RATE (but leave it empty for now), label in H2 to read COUNT Make a list of rates in G2:G20 (say) In H2 =COUNTIF($B$2:$B$200,G2) Copy down the row Select H1:G20 and make a...

why is delay needed between $Host.UI.RawUI.KeyAvailable and $Host.UI.RawUI.FlushInputBuffer()
The code below is an example of a way to stop and restart PowerShell code. Unless I put Start-Sleep -milliseconds 500 before $Host.UI.RawUI.FlushInputBuffer() it won't work. The delay also cannot be too short or it won't work. Why is the delay needed between $Host.UI.RawUI.KeyAvailable and $Host.UI.RawUI.FlushInputBuffer() ? 1..100000 | % { if ($Host.UI.RawUI.KeyAvailable) { 'Press any key to continue' Start-Sleep -milliseconds 500 $Host.UI.RawUI.FlushInputBuffer() do {Start-Sleep -millis...

Req: Formula Array.....
Hi all, Have an XLS and trying to generate stats from it. On one Worksheet I would like to break up stats in the following manne (for example).. Code ------------------- Ongoing Closed July Client Praises ?? ?? Complaints ?? ?? Vendor Praises ?? ?? Complaints ?? ?? Partner Praises ?? ?? Complaints ?? ?? The data contained on another Worksheet is in the following format: Col#01 - Date (Format: `dd - mmm - yy`) Col#02 - T...

formula #48
=IF(OR(ISERROR(SEARCH("CMT",A4)),ISERROR(SEARCH("DIVS",A4)),ISERROR(SEARCH("FUND",A4))),"", IF(LEN(A4)>3,1,"")) i have this formula which should return a value of 1 if A5 contains more than 3 letters except if A5 contains CMT, DIVS or FUND what am i missing? many thanks Well, I'm assuming you mean "A4", not "A5", in your statement. If A4 is the target cell, try: =IF(OR(LEN(A4)<=3,SUM(COUNTIF(A4,{"*cmt*","*divs*","*fund*"}))>0),"",1) HTH Jason Atlanta, GA "Micay...

custom stationary margins help
Hello I dont think I've posted to Microsoft before. I've searched for hours for the answer to this question, and can't find it anywhere. I'm using Windows XP, Microsoft Outlook 2003. I've downloaded some custom email stationary from places like www.stationary. org, www.thundercloud.com, etc. I love it except for two things ... I don't particularly care for the scrolling; is there any way to make it not scroll? And, margins. When I click "New" and get a blank email, the message ends up starting at the left side, as it normally would, but with t...

Experts Question
Hi. I'm writing a multi tool application, something like outlook. I have an MDI application of course. Inside the MDI the user may choose any of few Mini tools (something like calendar,contacts,mail, tasks etc). A mini tool may be an MDI - e.g. one of my mini tool is a resources editor, which means that the user may first choose the "Resource Editor" mini tool, and open/create many windows to edit. Another mini tool will be "Scripts Editor", which the user may choose to open many scripts views. My problem is how to implement the switching between mini tools, I wanna pu...

Simple Simple Simple
Just started Excel (again) and need to make an easy speadsheet fo calculating square inches. Column A: Height Column B: Legnth Column C: Total Tags per 16 x 24 Column D: Cost per tag Figures I know: each sheet cost me $9.98. each sheet is 16 x 24 inches What I want to do is enter the Height, enter the Length and have th total (sum) be entered into columns C and D. I can't believe I forgot how to enter formulas. Any help will b appreciated. Thank you, Crai -- Message posted from http://www.ExcelForum.com Hi Craig, One Way, might be better ways but this'll work: List the colou...

Simple help with implementing Outlook-like GUI
Hi All. I am an experienced unix programmer who sometimes has to do something in the windows world, and always has newbie-questions. Basically I want to write an application program that looks like outlook in that it has nice icons down the left hand side that choose the content of the main area in the right hand side. So I started the MFC App wizard, and got me a SDI program with a CLeftFrame (CTreeView) and a CMainFrame (CFrameWnd). Then I prepared the following snippet of code to draw the buttons: // Create a pushbutton CBitmapButton* pmyButton; pmyButton = new CB...

xml/rid question
I am using Visual Studio 2003/C# I created a new xml schema/xsd file (Project Create new item->Dataset) I then added Elements to the schema using the designer From the toolbox I then created an instance of my dataset. I then dropped a grid (Infragistics UltraWebGrid) onto my form, and bound the grid to my dataset. At runtime, I configure the columns of the grid, get some records from the Employee database (SQL Server2k), and add some rows to the grid. The user then enters some data into various cells of the grid. I am now ready to update the database with the contents of the grid. What ...

Column mailing list needs to be converted to rows
I have been handed a list that I need to convert and I am stumped. The worksheet contains three columns of addresses. The addresses are generally in one of three formats: Company Contact Street number and name City State Zip or Name Street number and name City State Zip or The repeat of the above with two lines for street information. As far as I can tell so far, these four are the only the different formats. Some of the addresses have a comma between the city and state. One final complication, some addresses use the 5 digit zip, some use the zip+4 with a dash. Is there a way to con...

vlookup formula #4
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C8FEBA.BDA26D90 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: base64 SSBoYXZlIHNvbWUgcGFydCBudW1iZXJzIHRoYXQgSSBhbSBzZWFyY2hpbmcgZm9yIGV4dGVybmFs bHkgdXNpbmcgdGhlICJGYWxzZSIgcXVhbGlmaWVyLiAgU29tZSBmaWVsZHMgcmV0dXJuIGEgdmFs dWUgb2YgIiNOL0EiICBhcyB0aGVyZSBpcyBubyB2YWx1ZS4gIENhbiBhbnlvbmUgaGVscCBtZSB3 aXRoIGEgZm9ybXVsYSB0byByZXR1cm4gYSBmaXhlZCB2YWx1ZSAoaS5lLiAxLjApIGlmIHRoZSBm b3JtdWxhIHJldHVybnMgIiNOL0EiIGFzIGEgdmFsdWU/DQoNCg0KVEhhbmtzDQoNClBhdWw= ------=_NextPart_000_0008_01C8FEBA....

Install question
Hello, can I have SQL Server 2008 Express with advanced services with SQL Server 2008 Enterprise Evaluation installed on the same machine ? Thank you Gilles On Fri, 30 Apr 2010 07:49:10 -0700 (PDT), Gilles Koffmann <gilles.koffmann@gmail.com> wrote: >Hello, > >can I have SQL Server 2008 Express with advanced services >with SQL Server 2008 Enterprise Evaluation installed on the same >machine ? > >Thank you >Gilles Hi Giles You should be able to do this, have you tried and failed? John ...

Simple hack to get $500 to your home. 06-05-10
Simple hack to get $500 to your home at http://uknews.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...

Simple Query Wizard hangs
I am using Access 2003 When I initiate the "Simple Query Wizard", I am presented with the first screen - "What fields do you want in your query" When I click on the pulldown list to select a table, I get the following message: "The expression On Get Focus you entered as the event property setting produced the following error: the text you entered isn't an item in the list * the expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the function, event, or macro&q...

Combining Text with Formula
Is is possible to have a cell contain text information and then a lookup to another cell. For instance: "The age of this person is " plus the result of another cell that calculates his age so that cell would read: "The age of this person is 72." Thanks for any help you can give me. DebraAnn DebraAnn, yes. =The age of this person is "&B1&"." where B1 holds the calculation. -- DDM "DDM's Microsoft Office Tips and Tricks" Visit us at www.ddmcomputing.com "DebraAnn" <anonymous@discussions.microsoft.com> wrote in...

I Need a Simple Sales Software
Hello, I am looking for software to keep track of my prospects, customers, and the notes of the sales process. I spend about one hour a day on sales and marketing, so I prefer a simple and inexpensive software. Maximizer, Outlook, Act, and Goldmine seem made for the full-time professional salesperson. Please let me know if what I am looking for exists. Best Regards, T.I. ...

Help with categories
Is there a way to create a third category partition? I currently have a category called 'gifts', with subcategories of 'birthday', 'christmas', etc. I use the memo field to record to whom the gift was given. Unfortunately, I cannot sort and subtotal on the memo field. My only known option is to download to excel and sort on the memo field . although I'd like to do it directly from Money. Thank you! You can't create a sub-sub-cartegory, but think of using a classification instead. Then you can look at your classifications and view reports based on thes...

VBA or Macro Help: Create new files based on dynamic text in a tab
I have 7 tables in a Word doc. Each table has a cell for "Owner". Suzy is the owner in 4 of the tables, John is the owner in 3. I want to loop through all possible owners (in this case, 2), find each table that belongs to them, and create a new file for each owner. At the end of the macro, I'd have a file called "Suzy.doc" with her 4 tables appended and one called "John.doc" with his 3 tables appended. I could code this back in the day by looping through a 'getOwner-readWordDoc-testCondition-writeRecord' loop-until-end. But, I can&#...

WDF Interrupt question
I'm sorry I just start learning windows drivers development. I'm looking at Interrupt servicing in drivers in WDF. WdfInterruptCreate create the interrupt object but where do we put the information about interrupt vector? I noticed we can get vector by using WdfInterruptGetInfo, but where do we set it? I think I have found where it comes from. From Hardware Resource list, which is filled by PnP Manager. On Mar 22, 12:56=A0am, mpefareo <mpefa...@discussions.microsoft.com> wrote: > I'm sorry I just start learning windows drivers development. I'm looking ...

OAB Needed?
I am STILL getting 0X8004010F errors in my Synch Issues folder on Outlook 2003 every 5 minutes. The error has to do with the offline address book. Do I really need this thing? I am never offline so I was wondering if there was a way to remove this stupid thing. We have only 1 Exchange 2003 SP1 server in our entire domain. This error is driving me nuts and nothing suggested so far has solved the problem. Is there another place to look? Thanks. David I resolved the 0x8004010F issue by creating a new Outlook profile. Evidently had nothing to do with Exchange 2003 server. David ...

Formula #21
I am making a worksheet in excel and I have a YES NO cells. I would like to be able to black out the cell I want to answer. Ex. if my answer is yes I would like to click on the cell and it would automatically turn black. Is that something that would be possible? could you use a "if" formula? -- ml format>conditional formatting>cell is equal to yes>format as desired -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com "cybersox" <cybersox@discussions.microsoft.com> wrote in message news:009549FA-3704-4A4F-8492-DCB9ECAF2B65...

Make it more simple or intuitive to do simple things
I appreciate the fact that applications are becoming more versatile and able to do things that we hardly thought possible in the past but I feel that in this added complexity you are losing sight of the need to do simple things easily without resorting to trial and error or consulting "help" which often anyhow doesn't lead one straight to the solution! An example is how to produce a chart with a series of months i.e Jan Feb Mar etc appearing on the X axis. This is no doubt something that resulted naturally in the first versions of Excel charts or in a competitor's ea...

Simple public folder permission problem
I have a public task list folder. However even though I have given everyone "Author" priviledges and full control of the directory, users cannot update the tasks (although they can create new ones). The changes to tasks get reset to their original values. Where should I look to fix this problem? Brian How did you grant Author Access, via Outlook or ESM? What do you meanyou gave them full control of the directory? "Brian Taylor" <taylorb@newsgroups.nospam> wrote in message news:e2hwumGrEHA.1160@tk2msftngp13.phx.gbl... > I have a public task list folder. Ho...