Over 1 million tech questions and answers.

Solved: Excel adding numbers

Q: Solved: Excel adding numbers


I am having trouble with Excel 2003 automatically adding the last digit in a Postal Code. For example, when I type in "R3R 4K5" in A1 and then click the corner of it and drag it down a couple of cells it goes from "R3R 4K5" to "R3R 4K6" and "R3R 4K7" and so on.

Is there an option that you can disable to prevent this?


Preferred Solution: Solved: Excel adding numbers

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Excel adding numbers

Read other 10 answers

Hello group,

I wasn't quite sure how to word the subject line. I would like to be able to add a number to column A everyday and have the cumulative sum of column A show in column B in the adjacent cell so I can chart it. So it would look something like this:

1 1
1 2
1 3
2 5
-1 4

I think it's something to do w/the SUM function but I can't quite figure it out. Any help much appreciated.


A:Solved: Excel: Adding Numbers in a Column on a Daily Basis?

Read other 7 answers

Hey everybody.

I don't know if the title is a good one for this problem, but here goes.

I have a column that has numbers in this format: 54321-1234

Now, I want to take off the last 4 numbers, and the dash, from all the numbers in the column, using a formula. So that the output would be: 54321.

I want it so the first 5 numbers stay the same, but the dash and last 4 are gone. Is this possible?


A:Solved: Excel 2003: Replacing Large Numbers with Smaller Numbers

Read other 13 answers

Can anybody help with this question? I have a massive spread sheet with numerical data in it. on paper I have associated a number to different ranges.

For example in columb A any number that is between 25-30 needs to be converted to 0.375. Can anyone tell me a quick way to convert these and other numbers in one go?

A:Solved: Changing all numbers in excel?

Read other 9 answers

I've been trying to write a simple formalue for Excel to generate a random number in a cell when I press the 'enter' or any other key. I've been trying with using =randbetween(1,100)

Any tips please ??


A:Solved: Random Numbers - Excel ??

Read other 10 answers

Here comes the dumbest and easiest Excel question ever, folks....!

In 1 column I have 8-digit numbers like 73269090. I need them all to take on the format xxxx.xx.xx (7326.90.90). For the life of me I cannot figure out how to accomplish this in the "Custom" menu of "Numbers".

Who will help the most ignorant Excel user ever??

Cheers [email protected]

A:Solved: Reformat Excel Numbers

Read other 11 answers

i have used the code below, so that when i enter a number in cell e7 a running total is shown in h10, and all figures entered in cell e7 are shown individually in Column L, is it possible instead of entering a number manually, can the number be generated randomly when a command button is pressed, i would need numbers generated randomly between 0 and 50
Private Sub Worksheet_Change(ByVal Target As Range)
Dim WB As Workbook, ws As Worksheet, wsk As Worksheet
Set WB = ThisWorkbook
Set ws = WB.Worksheets("Sheet2")

If Not Intersect(Target, Range("E7")) Is Nothing Then
ws.Range("H10").Value = ws.Range("H10").Value + ws.Range("E7").Value
x = WorksheetFunction.CountA(Columns(12))
Cells(x + 1, 12) = Target
End If

A:Solved: random numbers excel

Read other 16 answers


Can anybody guide me to generate continous numbers from 1 onwards while I filter the records? I need to generate these numbers in first column in order to know how many records are available after filtering.


[email protected]

A:Solved: Excel - Generate countinous numbers

Read other 12 answers

I keep a monthly budget record of our expenses in worksheets labeled by month. There are 13 worksheets in a file (1 for annual total). I have row labels such as "wine, food, our cats, etc" & enter data from our joint account, as purchases are made, into each cell. E.G.: B12 might be: =34.66+73.45+2.68 etc. At the end of the month I "proof out" our account to reconcile it with my bank statement. There are always missed or multiple spreadsheet entries that make the excel total different from the banks & I have to find them. I use online banking & my probem began when the bank "upgraded" their online service & no longer allowed me to sort the debits by amount. Before they did this I could look at the excel cell entries & find them very quickly on the banks sorted printout & check them off. Since I can no longer sort the banks data it has become much more difficult to do this monthly chore. Is it possible to sort the multiple number entries in each cell & display them in a column? BTW: I don't mean to sort within the cell, but all cells contents together for display, so it will look like the banks used to look.
Any help really appreciaced.


A:Solved: Excel: can I display all numbers in cells?

Read other 9 answers

First time posting...I am working on a spreadsheet for work in calculating a benefit. I have listed in C13 a minimum benefit (currently $25, but it varies). Later in the spreadsheet I subtract two numbers (c32-c33). If the number is less than zero, I have the formula put 0 in C34 as the answer IF(C32-C33<0,"0",(C32-C33)). That works fine. The problem is that later I when I want to list out what to pay, if the final answer is less than the minimum, I want the minimum to show, otherwise I want the calculated answer to show. Here is my formula. IF(C34<C13,C13,C47) Everything works great unless the original numbers subtracted is less that zero....for example $600 - $600 - the final results spits out the minimum of $25. Perfect. But when $600 - $601 = really equals -1, but I have it showing 0, the final answer spits out 0, not the $25 that I want. Any ideas on what to do to get it to put the C13 value instead of 0? Thanks so much for the assistance!

A:Solved: 2003 Excel Negative numbers

Read other 11 answers


I was wondering why numbers show up that way and what it generally means.

I can double click each cell in the column and it will show the real number i need, such as:


Is there a way to convert the whole row, so the numbers will show normally.

this should be just a general format.. this is just a generic id, and not currency or any other special format.

I use excel 03/07 both.

A:Solved: why do numbers show up as 6.34479E+11 in Excel. ???

Read other 8 answers

I am trying to create a template in excel with the name, address, and number repeated three times on one page and then when the template opens again I would like it to assign the new name the next sequential number so that no numbers can be skipped or used twice. See below. Can you help? Thank you in advance.

Jane Doe
1 Main Street
Anytown, Fl

Jane Doe
1 Main Street
Anytown, Fl

Jane Doe
1 Main Street
Anytown, Fl

A:Solved: Excel Template with Sequential Numbers

Read other 10 answers

I have an Excel workbook that prints many pages. With this workbook, after the 7th page I insert pages from a different program, and then the rest of the Excel workbook pages follow.

The Excel workbook is actually 20 pages long.

I need a way to create a macro that will insert 1 of 20 pages on the first seven pages of the Excel workbook pages. Then since 2 pages from another workbook will be added before the other 13 Excel pages, I need the numbering to reset to show 10 of 20.

Does this make sense? Can this be done?

A:Solved: Excel Macro -> Page Numbers

Read other 15 answers


time data result
12.00 1
12.05 1
12.10 1 3
12.12 - 2
12.25 -1 -3
12.40 1 1
12.55 -1 - 1
1.05 1
1.16 5 6

can any body help in making a macro that sum the same signs numbers in column C and put the results in in column D as in the examples above
and every time that i start the macro ....it will start to calculate from the first cell D2 and go down
hope to find this macro

A:Solved: macro to sum numbers with same signs in excel

Read other 6 answers


I currently have data that is pulled from a database with a collumn which represents the time a call was logged. However, the information in the cell shows as 130237 when it should show as 13:02:37. How can I manipulate this and also be able to change the formatting to time. Currently if I try and format it, it shows as 00:00:00


A:Solved: Excel - Numbers into a time format

Thats coming in as a full date - so
130237 is the date


if you change to a time format and also use value - then it will be seen as a time

assuming the time is in cell G8 and you always get leading zeros - which maybe a problem for 9am


Read other 3 answers

First, Thanks for looking !

I have to create a spreadsheet with numbers that repeat for merging into another program. The number sequence is:


When I type in a sequence of them and then drag and fill I get the decimal versions after the original set I typed in, which since it is rounding, tends to jump or repeat a sequenced number:


How do I get it to repeat the number twice, but not skip or repeat based upon the rounding of the decimals that are hidden?

Thanks again!

A:Solved: Excel Autofill - Double Numbers Capable

Read other 7 answers

I have used MS-Excel for many years and am fairly familiar with with using formulas. However I am a total novice when it comes to creating and using Macros. I am using MS-Excel 2003 and have run into a requirement that I don't think can be handled with just formulas.

I need to create several arrays of random integers. The number range and the quantity of numbers is determined by numbers entered into other cells. So far, I could do that with formulas. The catch is that each array can not have any duplicate numbers in it. There also needs to be an error check to make sure the number range is equal to or larger than the quantity of numbers needed.

I have attached a file that shows the workbook layout and includes examples of the type of arrays I need to generate. All help and guidance is welcome and will be appreciated.

A:Solved: Creating arrays of random numbers in Excel

Read other 16 answers

It's hard to come up with a snappy title that sums up my problem but I'm hoping it will be fairly simple to solve.

I've created an IF formula in an excel spreadsheet and I want to drag the cell across a few more cells. The formula will reference the same cell so I can make that an 'absolute reference' but then I want the logical test number to increase by 1 each time and the value if true to remain the same.

=IF($A$1>0,1) [in the first cell, then in the next to the right]
=IF($A$1>1,1) [then]
=IF($A$1>2,1) [and so on]

Can anyone please tell me if this is possible? and if so, how??!!

heres hoping,

A:Solved: Can you drag formula in excel so the numbers increase?

Read other 16 answers


I am using office 2000 and windows 98. I just had it all re-installed and now when i open up an old spreadsheet it shows the negative numbers just with the minus sign infront of the number. Where as before all the negative numbers would automatically appear in Brackets.

Does anyone know how to change this back?

A:[SOLVED] Excel 2000 negative numbers in Brackets

Read other 7 answers

Hi All

I have a spreadsheet full of numbers formatted as currency. Some dollar amounts are positive and some are negative. I want all the negative numbers to be in red font. Instead of me searching for all the negative numbers (they are in the hundreds) and turning them all red manually, is there a simple macro that can do the trick? This will save me a lot of time. Since the numbers change from negative to positive and vice versa and the number of rows and columns also change, I'm having a hard time programming it.

Has anyone out there written a macro than can do this?



A:Solved: Turning negative numbers to red font in an Excel spreadsheet

It's built into Excel - just highlight the cells, go to format cells.
Go to Currency. There are 2 boxes on the right - the lower one allows you to have negative numbers in parentheses ($3.00) or red $3.00 or a combination of those two or with a minus sign.

Read other 3 answers

I'm using VLookup & need my reference numbers on the current and the lookup pages to have that left apostrophe at the beginning of both sets of reference numbers or otherwise to have no apostrophe there at all. Without consistency I can't perform the lookup.

Is there a quick way to add or remove those apostrophes in a long list of numbers?

A:(Solved) Excel: remove/add apostrophes at beginning of long list of numbers

Read other 14 answers


I have an Excel document with hundreds of values all with leading zeros.
The number of zeros varies from cell to cell, and the cell lengths may vary, so I might have something like:


I need to remove the leading zeros from all cells.
I can't multiply by the values by 1, because of the non-numeric entries.
I can't Replace All zeros, cos it would replace any zeros that appear within the codes, not just the leading ones.
I can't do a Replace All searching for * then a specific character, because the first char of the code is not specific.

So I'm thinking I need to do something like:
=RIGHT(A1, FIND(<>"0",A1,1)-x)
Obviously that doesn't work, cos it doesn't like the <>"0" part, and I can't put a set number in place of the "x" at the end as the number of characters to return differs from cell to cell.

Or maybe use the SUBSTITUTE function somehow, though again I still need to tell it to stop when it hits a char other than zero, as =SUBSTITUTE(A1,"0","") applied to line 2 in my example data above would return 124 instead of 12004.


A:Solved: Excel - remove leading zeros (differing numbers) in Text cells

Hi Gram. I checked ASAP Utilities but couldn't see this covered.

Sub Macro1()
For Each Cell In Selection
x = Cell
If Left(x, 1) = 0 Then
Do Until Left(x, 1) <> 0
x = Right(x, Len(x) - 1)
End If
Cell.Offset(, 1) = x
Next Cell
End Sub

Read other 2 answers

Please can you tell me how to add page numbers to documents in Libre Office Writer.


Read other answers

Could somebody help me . I need to print a Word file, but every print has to be numbered. There surely must be some way of doing it automatically. HELP

A:Adding Numbers to a Printout

print out of what in what program
adding what type of numbers

assuming word
assuming page numbers
assuming XP

on the top menu
page numbers

Read other 3 answers

Not as easy at it sounds!

I have a cell with the following:


I need excel to calculate the total of these figures e.g =

this should give me a total of 169.

These figures are random e.g.

in each of these i would like the totals to be show eg:
Y189 - is 189
F2C77W10Y177 - is 266

Im stuck....

Read other answers

I need an Excel formula that will add a column of numbers by the date in which they (each number) occurred. The dates and numbers in sequence (which helps). For example, to add all of the monthly payments (by month) that will occur between 10/1/04 and 10/1/05 (in this case one payment per month) what could I use as a formula?

Help would be appreciated as Hurricane Francis blows right over my head here in Orlando.

A:Adding numbers between know dates

Here ya go: http://www.dicks-blog.com/excel/2004/03/sumif_between_t.html

Read other 1 answers

I have a company that sends people out into the field, the job may take more than one day and they may sell the same and different items each day. I am looking for an easy way to total these things up. I know Excel pretty well, but I can't figure out macros. What I would like to do is;be able to input Item #'s, have it look up the Description (which I know how to do), then I enter amount used, then on the side somewhere have it "auto sort" and "auto total" in either format as shown in Option #1 or #2 (I would really like it to show Option #2 & 1) Then I can review it with each item listed in order and give it to my secretary to enter into my invoicing program.

Item # Description Amount used
101 Truck 1
102 Pencils 6
205 Paper 8
215 Eraser 4
318 Envelope 10
101 Truck 3
319 Paper Clip 2
102 Pencils 5
318 Envelope 8
101 Truck 5
217 Ink 2
319 Paper Clip 8
205 Paper 2
215 Eraser 4

Option #1
Item # Description Total Used
101 Truck 9
102 Pencils 11
205 Paper 10
215 Eraser 8
217 Ink 2
318 Envelope 18
319 Paper Clip 10
Option #2
Item # Description Total Used
101 Truck 1
101 Truck 3
101 Truck 5 9
102 Pencils 6
102 Pencils 5 11
205 Paper 8
205 Paper 2 10
215 Eraser 4
215 Eraser 4 8
217 Ink 2 2
318 Envelope 8
318 Envelope 10 18
319 Paper Clip 2
319 Paper Clip 8 10

A:Adding numbers from jobsheets

Read other 10 answers

Adding rows 5 thru 10 on line 11 I use function, and get a total for column A. When I go to column B I have to type in function again - and also in C-D etc. Is there a way to get all the desired columns added on line 11? I use XP home with Excel.

A:Solved: Excel-adding columns

Just click on the bottom right of the total in Column A.
You should see a set of crosshairs.
Drag it through the other cells that you wish totalled,

Read other 1 answers


I found the attached vba code on the net and modified it slightly. It's purpose is to print all files contained within a folder, to WorkSheet1 of the active WorkBook. The code works like a charm. However, I would like the listed files to be hyperlinks so I could open up each file using the worksheet.

To this end, I recorded a macro that creates a hyperlink as outlined below:

Sub HyperlinkTest()

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="Corrective_Action_Requests.xlsx", TextToDisplay:="Name of Audito(s)"

End Sub

I then added this into the original code and tried numerous ways to get this to work, but to no avail. I just can't figure out how to fit this into the existing code to produce hyperlinks instead of just plain text.

If anyone can help me better understand how I can get this to work the way I want, it would be greatly appreciated.


A:Solved: Adding Hyperlinks using Excel VBA

I've managed to figure out how to tie in the additional code and get the results I wanted. If any one is interested, this is the code that worked for me.

Sub LoopThroughFolder1()
Dim r As Integer
Dim fileSystemObject
Dim FolderObj
Dim fileOBj
Dim arrFileName
r = 2
Set fileSystemObject = CreateObject("Scripting.FileSystemObject")
Set FolderObj = fileSystemObject.getfolder("G:\QMS_Files\Record_Logs")
For Each fileOBj In FolderObj.Files 'loop over the files in the folder
If Not fileOBj.Attributes And 2 Then 'only show files that are not hidden
Cells(r, 1).Value = fileOBj.Path
arrFileName = Split(fileOBj.Path, "\")
Cells(r, 2).Value = arrFileName(UBound(arrFileName)) 'Get the File Name

Cells(r, 1).Hyperlinks.Add Anchor:=Cells(r, 1), Address:=Cells(r, 1).Text, TextToDisplay:=Cells(r, 2).Text

Columns(2).Delete 'get rid of extra column
End If
r = r + 1
Next fileOBj
End Sub

The only thing now is to figure out how I can leave the path the way it is, but get the code to read the drive letter in case I move the set of files to another computer with a different drive. Like if I took the whole set of files and put them on a memory stick and then plugged it into another computer which may end up being drive D, E, F, G or H.

Has anyone got any idea of how this could be done?


Read other 2 answers


I have a bank statement in Excel. What I want is a formula to pick out all the bank charges, for example, and add them in a single cell, so I can tell at a glance how much has been paid. I've attached a sample.

Thanks in advance!

A:Solved: Excel - Adding from a list

bleep69 said:


I have a bank statement in Excel. What I want is a formula to pick out all the bank charges, for example, and add them in a single cell, so I can tell at a glance how much has been paid. I've attached a sample.

Thanks in advance!Click to expand...

Could not open your example file.

However I believe, your problem can be solved by using SUMIF function.
Lets say when ever there is bank charge the statement is using the term "bank chaarges". Plus this text always appear in column A and the corresponding values appear in column B.
The formula where you want the total for bank charges levied will be:
=sumif(A1:A20,"Bank Charges",B1:B20)
(assuming that the range is the first 20 rows)

Read other 2 answers

Is there some way to make it so page numbers display on the printed pages of an Adobe .pdf file? I converted a Word document to .pdf, but the Word document did not have the numbered pages. I now want to add the numbers in Adobe Reader, but it looks like I'll have to go back to the original Word document, add headers which include the page number, and then re-convert it to .pdf. Is that correct? If I could do it within Adobe Reader, that would be preferable.

A:Adding Page Numbers to .PDF document

The file is a creation from an original Word file, the page numbers would need to exist in the Word file.

It would be a nightmare if in creating a PDF it was able to assign new printed page numbers as these would often not align with the original document and TOC's would be incorrect.

Read other 1 answers

Hi All,

Anyone know how to add and total up numbers in a table cell? Thanks.


A:Adding and Total Up Numbers in a Table

Read other 6 answers

I have a new 11e laptop, 3rd Generation. Everything was working good. All of a sudden, the keyboard when typing only the middle row letters of "a,s,d,f, j, k, l, ;" a number will be added in front or to the back of the letter. All other keys are typing fine. I have checked for anything NumLock that could be related to causing this. Nothing in BIOS Set. Checked keyboard settings - the correct language is set. I tried to press FN+F11 and nothing. I turned on the online keyboard and clicked on NumLock there and turned it off, that did not fix it. I attached an external keyboard, that types fine. Turned on and off num lock, that did not fix it. I did a restore back to a date before it happened, that did not fix it. I just reimaged the laptop and that did not fix it. Any suggestions would be much appreciated!

Read other answers

Im using windows 10 totally updated version and the problem im facing is that windows keeps adding numbers after my WiFi name/SSID and the number keeps on increasing. It aint causing any trouble with network usage but I still wanna fix it and wanna know whats causing this. Ive attached a picture with this thread where u can see the wifi name states Redmi 7 but my network name is just Redmi. This 7 was 2,3,4... some days ago. Please help me asap with this issue ill be grateful.

A:Windows keeps adding numbers after my WiFi name

I don't understand why that is a "problem" or why you are bothered, but I don't need to understand. In Network Connections you can right click on the connection name and select Rename and call it whatever you wish (within reason). I should add that you could do this in previous versions of Windows but I'm only assuming the ability has not been removed in Windows 10.

Read other 1 answers

I have a formula that sums the value of cells within a table depending on their background color...

i'm trying to use this formula but i also want to check if the cells are on a row that is within a certain date range eg. 2014/01/01-2014/01/31.

i've tried using my sumbycolor statement adding an IFS statement to it but excel doesnt like it

if anyone can help thanks in advance

A:Solved: Excel adding an IF statement to formula

Read other 7 answers

Hi, first time poster long time reader...

The problem I'm having is that I need to be able to check for certain values in Col A (i.e. value1, value2, value3, etc) and then add the corresponding values in Col F together for a total.

For example...

A23: Value1 ------------------------- F23: 2
A24: Value2 ------------------------- F24: 9
A25: Value1 ------------------------- F25: 14
A26: Value4 ------------------------- F26: 38
A27: Value1 ------------------------- F27: 5

You'll see there are three cells in Col A set to Value1. I would need a cell to hold the sum of each value in Col F for every row that contains each Value#. The output for Value1 would be 21 (F23 + F25 + F27).
I tried variations of VLOOKUP but that only returns one of the values in Col F and since I need to get totals relative to the Value# in Col A, that doesn't really work.

Thanks in advance!

A:Solved: Excel: adding (v?)lookup values

Take a look at the SUMIF function


Read other 3 answers

Ok I have tried to figure this one out myself and to no avail.

What I am trying to do is create a macro that would add text at the end of the text in a current cell.


Company 1
Company 2
Company 3

I am trying to create a macro that would would go thru each cell and add "Total" to the end.

Company 1 Total
Company 2 Total
Company 3 Total

Every time I try and create a macro, it copies the previous text into the current cell.

Thanx in advance.

A:Solved: Excel Macro Help - Adding Text

Read other 15 answers

Urgent need to hear from you more knowledgeable members (i.e., everybody!) as to exactly how to add rows which was so simple in earlier Excel versions, but now is bafflegab. Even after several efforts to comply with what follows when at INSERT, all I got was to move cell I'm in one to the right with all other cells in the row following suite.
OF COURSE I had specified "entire row".

Why this should be so difficult I know not. Please advise ASAP. Thank you.

A:Solved: Adding ROWS Excel 2007

Read other 16 answers

I want to add text to the end of the output of a formula in Excel 2010, but can't find the right sintax. I've done this before in Excel 2003, I'm sure the text needs to be double quotes but how to add it to the formula???

e.g. the basic formula could be =sum(A1,A4) where A1=12 and A4=13 and I want it to display 25 apples

A:Solved: Excel - adding text in formula

Read other 6 answers

Hi all,

I'm a newbie here so I appreciate any help that is offered. I searched around the forum here a bit, but could not find anything matching my exact needs (similar posts used combo boxes or just needed a single picture... not quite what I need)

I'm trying to create a product catalog for a client.
The product info is stored on a database and is being pulled into excel via an excel ODBC Query. One of the fields is the image name (product01.jpg, product02.jpg, etc..). The images are stored on the hard drive. The list of products will be different everytime depending on what the user filters in the query.

I need to be able to include the images in the product list.
Sample fields are ProductId, ProductName, ProductCost, ProductImage.
I'm guessing this will need VBA code to work. I'm not familiar with VBA coding, but with some help I'm sure I can get it working. Ideally, the pictures should show up as 125x125 pixels and the rowhight for each row should match the image hight.

All this needs to be dynamic as one time the query might return 10 rows, and another time 150 rows.

Running Windows XP with Excel 2003.

Any help is appreciated!

A:Solved: Need help adding images to excel (dynamically)

Read other 16 answers

About a year ago, I created an input form that contains a subform in which are listed all the contributions of a member of the organization. Under the subform -- IN THE MAIN FORM, not within the subform -- I had placed a field that summed the contributions for that individual, and another field that displayed the domain sum (DSum) for all contributions. Both have worked perfectly every since.

The field that sums the contributions for the individual used the formula "=[Contributions subform].[Form]![ContribSum]". The field that does the domain sum is "=DSum("Contribution","Contributions")+IIf(DSum("MatchAmt","Contributions") Is Not Null,DSum("MatchAmt","Contributions"),0). I removed the field "MatchAmt" from the table, and changed the DSum statement to just "DSum ("Contribution","Contributions").

After doing that, both field yield only "#Error". Part of my puzzlement is the field "ContribSum". It is not a field in either table, and is nowhere in either form. I haven't the foggiest where it is or why the formula refers to it. I tried using just "=Sum([Contributions.subform].Form![Contribution]), but that for some reason reports only the first contribution; doesn't add all of them up.

So my question is, how does one sum number fields in a subform in a field OUTSIDE of the subform/in the host form?


A:Adding numbers in a subform (Access 2000)

Put the "=" back in front of DSum, so that it says this:

The "#Error" means that Access is trying to do some sort of operation that it can't pull off.

As for your sum question, it's cagey, unless you can program a little. The workaround is this:
In the subform, show the form footer. There should be a control there called ContribSub, I'm guessing, from your post. If not, make one.
Set its control source to


Once you're sure the subform sum is working, you can set the Visible property of the form footer to false. That way you don't see your total down there.
Now you can build a control source on the master form whose control source is set to

=[Contributions subform].[Form]![ContribSum]

As for why your other attempt wasn't working (the one that goes like "=Sum([Contributions.subform].Form![Contribution])"), you must remember that Access maintains only one "active" record at a time, per form or subform. So your control wasn't lying; I'll bet changing records in the subform would prove that. But it's only adding the total of the active record--this is the big difference from a report, where there are no active records.

Hope this helps. Let us know.

Read other 2 answers

I have a workbook to keep track of total and monthly sales. Worksheet 1 is Total sales, worksheets 2 - 13 are monthly sales.
If I get a new customer and want to add the record I currently have to add it to every worksheet manually.
I want to be able to add a new row to the total sales and it be automatically added to the other 12 worksheets.
I have tried selecting all worksheets and right clicking but the add new row button is faded out and won't let me click it.

A:Solved: Adding rows to multiple Excel worksheets

Worked it out. I had the data in tables. Converted back to range and it is working fine.

Read other 1 answers

Hi everyone,

I have a macro that retrieves some data to excel and populates an excel table (listobject) using vba. The table is large (8000+ rows and 6 columns). There are another table that does some calculations based on the first table. Although the calculations is set to manual, when I send data to the table , I have an impression that the second table is recalculated too, because it takes a lot to add the data (but if I remove the second table it takes just a few seconds compared to 1,5 minutes).
The same is with the table resize.

Can somebody to advice on how to set excel so it calculates everything at the end of the code and not when the data is added to the table. Currently this settings are in place:
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Application.EnableEvents = False

Using Excel 2010 and 2007.

A:Solved: Adding data to excel table (listobject)

Read other 16 answers

Help please.

I've done a excel spreadsheet, where across the sheet in a line with maybe a few letters 'x' or 'H' or 'BH' and the next line will have the same. This could be from line 8 to line 121.

But in a column say 'T8' to 'T121' I want to count the total number of 'x's in that column, also 'H' and 'BH' giving the total individually. ie:- x=3 H=6 BH=4 for column 'T' and the same with the other columns.

Can this be done, please.

A:Solved: Help required with Excel adding letters in columns

you could do a count in seperate columns

in A1
=COUNTIF(T8:T121, "X")
in A2
=COUNTIF(T8:T121, "H")
in a3
=COUNTIF(T8:T121, "BH")

Read other 3 answers


I want to add manually data\formulas to my excel sheet and I get a popup error message:

please see the attached file.

ps: I unprotected the sheet.

Where do I set the flag to allow to add data to my cell. It doesn't allow me to add in some cells. Why is that?.. Some work and some dont..

Thank you

A:Solved: error adding data to excel cell.

The cell is "protected" with Data Validation. Activate the cell and go to Data/Validation and either delete the Settings or click the Error Alert tab and set the Style to Warnng or Information.

Read other 2 answers

Hi guys,

I've got some lovely code that add appointments to outlook, However I would like it to check to make sure it's not adding in a duplicate entry, I have seen an answer on here but I couldn't get it to work, I'm not exactly a super user!!

My code is:
Sub AddToOutlook()

'!! Reference to Outlook object library required !!

Dim olAppointment As Outlook.AppointmentItem
Dim olApp As Outlook.Application
Dim lngRow As Long, shtSource As Worksheet
'Get reference to MS Outlook
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If Err.Number <> 0 Then
Set olApp = CreateObject("Outlook.Application")
End If

On Error GoTo 0

Set shtSource = ActiveSheet
For lngRow = 3 To shtSource.Cells(Rows.Count, 10).End(xlUp).Row

Set olAppointment = olApp.CreateItem(olAppointmentItem)

With olAppointment
.Subject = shtSource.Cells(lngRow, 2) & " " & shtSource.Cells(lngRow, 3) & " " & shtSource.Cells(lngRow, 4)
.Start = shtSource.Cells(lngRow, 10)
.Duration = 100
.Location = shtSource.Cells(lngRow, 6)
.Body = shtSource.Cells(lngRow, 6) & " to " & shtSource.Cells(lngRow, 7) & " Departing " & shtSource.Cells(lngRow, 10) & vbNewLine _
& shtSource.Cells(lngRow, 8) & " to " & shtSource.Cel... Read more

A:Solved: Adding appointments to Outlook form Excel with VBA

Read other 6 answers