Can anyone please help with this formula. If Sheet1 Column A = nothing(blank) And Column B = \\\\\\CC\\\\\\ Then Sheet 2 B7 = SumTotal. As a regular formula would be nice or VB code Hi Richard you want nothing at all in the whole of column A in sheet 1? do you want every cell in column B of sheet 1 to have \\\\\\CC\\\\\\ or should this (can this) only appear in one cell? and what range are you summing on sheet 2 in cell B7? Cheers JulieD "Richard" <anonymous@discussions.microsoft.com> wrote in message news:82ce01c477e1$77f0e740$a301280a@phx.gbl... > Can anyone please ...

I am using an =Ave function in a formula to average quite a few cell values together. I add new information all the time; sometimes 5 or 6 new cells at a time. How can I append or up-date my formula to include these new cells with out have to type the new cells into the formula? When I make the cell that has the formula in it active/edit, all of the cells that are referenced in the formula have a highlight around them. Is there a key or key combination I can press while clicking on the cells I want to add to the formula? Thanks, john Hi see your post in Excel.misc -- Regards Frank ...

I have a working SUMPRODUCT formula {=SUMPRODUCT(($C$4:$C$4341=z8)*(audittypefm1="Standard"))} that I need to change the 1st array to C5623. When I do I get a #N/A error. I've tried giving the range a name (empnofm2), and I've verified all the data in the C4:C5623 range is formated the same (general, it is all employee numbers from 2 to 5 digits long. I'm using a "trim all" macro which is working great. I am unable to determine what is causing the #N/A and how to fix it. Basically I copied an entire worksheet within the same workbook and changed the name, wh...

I have 98 sets of magazines each set has 12 in the set what formula can I use to get a total of issues in all sets have you tried 98*12 -- Don Guillett SalesAid Software dguillett1@austin.rr.com "Just Me" <no@isp.com> wrote in message news:eZ66ZEGHGHA.1192@TK2MSFTNGP11.phx.gbl... >I have 98 sets of magazines each set has 12 in the set > > what formula can I use to get a total of issues in all sets > =98*12 or =A1*A2 if the numbers are in A1 and A2 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Just Me" <n...

I am using outlook XP on a P to P home network using windows 2000 pro on two computers. Is there a way of linking the contacts/address books so that if I up-date one the other is automatically up-dated too? Since you are on a peer to peer network there is not Exchange server so sharing mailbox and giving permission to share data is not available. Also your Outlook information is strored in personal folder (.pst file) on the local system. If the pst had been stored in central location on a server we could add that pst to the other system. I have not tried this but you may be able s...

I recently acquired a new computer. I have Office 2003 with SP1 and it includes Publisher 2003. Our church newsletter is created using Pub 2003. I tried to convert our church newsletter to web site format ( so that the newsletter can be posted to the web ) using the native tools of Pub 2003. I observed that the result is viewed fine in IE, but the result is pretty bad when using netscape 7.x or Firefox 1.0. ( I did review a lot of posts from this forum, and tried the suggestions of 'no vml' and 'no png', but it did not help. ) So, given that it appears that I can't change ...

I have a unbound control box (called textbox 20) in the details section on my subform that calculates unit price and units orders. The data source looks like this ...=[UnitPrice]*[UnitsOrdered] I want to get a running total set up on my main form. Before I do that I'm pretty sure I need to set up my header on the subform. In my subform, I entered another unbound textbox (called textbox 26) on the header with a datasource that looks like this =sum([textbox20]). Both of these control boxes are set to currency and when I try to preview the form, my header gives me a #...

Hi, What formula should I use if I want it to look at a specific cell and then work out the total number between two numbers. e.g. if cell H6 had 7-4 entered the number 9 would be returned. Thanks in advance I'm not sure how you got 9, but your life would be much easier if you used two separate cells and then subtracted the smaller from the larger (and then added one???). Boenerge wrote: > > Hi, > What formula should I use if I want it to look at a specific cell and then > work out the total number between two numbers. > e.g. if cell H6 had 7-4 entered the number 9 woul...

Can the offset be used in the below formula for the information in column "K"? In column L have the the following formula's L46 =MAX($I46*1000-$K$46*$J46,0) L47 =MAX($I47*1000-$K$46*$J47,0) .... L99 =MAX($I99*1000-$K$46*$J99,0) What I'd like to do is to copy the fomula into columns M, N, O, ... M47 =MAX($I47*1000-$K$47*$J47,0) M48 =MAX($I48*1000-$K$47*$J48,0) M49 =MAX($I49*1000-$K$47*$J49,0) .... N48 =MAX($I48*1000-$K$48*$J48,0) N49 =MAX($I49*1000-$K$48*$J49,0) .... O50 =MAX($I50*1000-$K$50*$J50,0) O51 =MAX($I51*1000-$K$50*$J51,0) .... How abou...

I have two widely separated computers, each running XP and WMP11. From Computer1, I have backed up my music (WAV) files onto a Western Digital (WD) "My Passport Essential" portable drive. I have changed the WMP "Rip" folder on both computers to the (deeply embedded) WD folder to which the WAV files were copied. My intent is to eliminate all WAVs from both computers (freeing space), transport the WD between computers and play music from the WD. Playing the music from the WD through WMP on C1 works great. However, when using the WD with C2, much information...

I have two text files that I would like to merge into one based on a common data field. One has persons' names and addresses, the other has different information about each person. Both have a unique ID number that can be used to combine the data. What is the best way to bring them together? Using Excel? or Access? What process should I use to get the text data into the program? then to combine the data? I'd appreciate whatever help anyone can give. Thank you, Jeanne Import the data into two separate Access tables. Create a new query using both tables as the data source. Mak...

I have a report that must be turned in the night before for tomorrow's date. Is ithere a date formula that will return tomorrow's date to a cell in Excel? One way: =TODAY() + 1 In article <668782AC-774A-475F-9821-8A4C3B14A983@microsoft.com>, "Shadyhosta" <Shadyhosta@discussions.microsoft.com> wrote: > I have a report that must be turned in the night before for tomorrow's date. > Is ithere a date formula that will return tomorrow's date to a cell in Excel? I assume that you want the date to remain static after entry. Easiest way, use 2...

Can anyone help with the weekday formula. What I want to do is enter the date in say A1 11/20/2003 and have B return the answer of Thursday. Currently I use the weekday formula bu only returns the number of the day. Thanks in advance B ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com There are several ways to do this. One is to enter =A1 and format the cell with a custom number format of dddd. Another way is to use the function =TEXT(A1,"dddd"). -- Cordiall...

Hi, How do I change the following formula =SUMIF($F$39:$F$79,"PW Shopfitters",$D$39:$D$79)/COUNTIF($F$39:$F$79,"PW Shopfitters") to count within a named range (PW Shopfitters). Any help would be great. Cheers, Phil Hi A range name cannot have spaces, maybe that's your problem. Name your range PW_Shopfitters. Then replace your cell references with PW_Shopfitters, eg =Sumif(PW_Shopfitters,"PW Shopfitters",............ -- j.kasselman@atlantic.net.remove_2nd_at. Randburg, Gauteng, South Africa "PW11111" wrote: > > Hi, > &g...

I receive daily API transation data. Each day the data is provided via a text file. Data is in columns. First column is date, second column is API (35 different APIs), third column is transaction volume and fourth column is average response time. I would like to create a chart with date on the x axis, transaction volume on the y axis, and each API as its own series. I can create a base chart for a single day with all series. I am having a problems adding in addition series data for each additional day? Is there an easy way to add data to each series? Create a PivotTable (and PivotC...

I have a form - record source is t0103Issue.(see below for fields) I would like to add a text box with a field (LevelorAdj) from a different table(see below for LevelorAdj) Textbox is named LJ table t013IssueDesc (add LevelorAdj to form) IssueDescID IssueDesc LevelorAdj table t0103Issue (for form) IssueID RiskID IssueDescID How is this done? -- deb Deb, in the form's current event, add: LJ=dlookup("LevelorAdj","t013IssueDesc","IssueDescID = " & [IssueDescID]) UpRider "deb" <deb@discussions.microsoft.com> wrote in message news:A710...

At least I think that's what I'm looking for. here's my situation: I've got a sheet where there is a variable (X) that changes depending on what row it is on. So I have a column (column c) that lists these variables (X is dependant on things from a different sheet). X is a muliplier that is utilized differently depending on the value of N. N is a Picklist selection and can change periodically. Or even be duplicated on more than one row. I have a vlookup that checks the value of N (column a) and needs to return a formula that has X applied if needed on the approp...

Hello. I have this formula loaded from a text field on a form: val([field10])+val([field20]) and I would like to use this as a code formula. I mean, if I use that in VBA code it works, but If I load from a text field it doesn't work. I need that my form use that formula stored in a text field to calculate values. Regards in advance, Marco responded to in another newsgroup. It's rarely necessary to post the same question to more than one group. If it is necessary, select all the relevant newsgroups in the "To:" or "Newsgroups:" field. That way, folks who...

Dear MS, How about a new function for this one. I'm sure MANY users have the same problem as me. The research below seems quite comprehensive and has effectively come up against a brick wall. Thanks Peter Harlan Grove posted this UDF: http://www.google.com/groups?selm=hkQVb.2432%24_4.259%40www.newsranger.com Peter wrote: > > Very Helpful Papou - thank you! > Do you know of an additional / alternative method where you achieve the same tihing but are not required to have all the relevant work sheets open? > Many thanks > Peter > > "papou" wrote: > ...

I created a two page e-mail in publisher 2003. How do I get it to send BOTH pages at once. it is a continuation of the first page on to the second. Thanks! Meagan You can't - emails are a continuous "page". You could convert it to something else and insert them into a single email. -- JoAnn Paules MVP Microsoft [Publisher] Tech Editor for "Microsoft Publisher 2007 For Dummies" "Meagan" <Meagan@discussions.microsoft.com> wrote in message news:21948F73-9B20-4069-B1E2-AE8EB05B5C83@microsoft.com... >I created a two page e-mail in publisher 2003....

What formula in access can do =COUNTIF(CAF!D:D,A3) Basicly I have 2 tables I want the 2nd table to count how many times a number is listed in the 1st table. I am trying to do this with a query and the count expression but keep getting errors. Dont bother with this one guys just figured it out AMDGUY [MCP] wrote: > What formula in access can do > =COUNTIF(CAF!D:D,A3) > > Basicly I have 2 tables > > I want the 2nd table to count how many times a number is listed in the > 1st table. I am trying to do this with a query and the count expression > but keep getting e...

What does the $ symbol mean in a formula? example: =G8*($A$14*2)*100 thanx The $ is used for absolut referencing. For e.g lets take your formula =G8*($A$14*2)*100 suppose you enter this formula in cell B2, now simply copy this formula one cell to the right (C2) by and one cell down (B3). C2: =H8*($A$14*2)*100 B3: =G9*($A$14*2)*100 So you see that The original G8 has changed, whereas $A$1 remains the same in both the new formulae because of the dollar signs. Mangesh "S" <S@discussions.microsoft.com> wrote in message news:D86597A4-C0A1-46AF-9DA6-FE06AB9C1FA0@mi...

Please tell me if anyone has solutions/suggestions/RMS add-ons available to mitigate system crashes especially for SO (with just one machine having both SO database and POS with SQL server 2005 express). How to deal with the case when crash is unrecoverable i.e. hard disks get damaged, how to retrieve sales data then? Secondly, how to deal with database size growth getting more than 4GB on SO with SQL Server 2005 express edition? Shifting to SQLSerevr Standard edition is out of question, cant do it... its a limitation. How to secure my sales data and how to keep RMS SO going? Some bod...

Hi, Let's say you have one sheet with a list of products. Column1 = product name Column2 = product number I would like to have a cell on Sheet2, where I can start typing something, and it would let me see a list based on what I typed so far. E.g when I type "Volks" it should show a list of all Volkswagen Cars. If I then choose the value, it should use this value and add the product number in the cell next to it. What function should I use, or how can I do this? Thanks, Roel Roel You could use Data Validation drop-down list for the selecting the product name and VLOOKUP ...

i dont know if you can do this..... if(c5=10, take the cell 5 right 3 down to it, 0) if you can, i dont know how to write it in excel language thanks if anyone can hel -- cutsygur ----------------------------------------------------------------------- cutsygurl's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1504 View this thread: http://www.excelforum.com/showthread.php?threadid=27569 cutsygurl Wrote: > i dont know if you can do this..... > if(c5=10, take the cell 5 right 3 down to it, 0) > if you can, i dont know how to write it in excel language &...