I have one column of imported data that contains about 12000 rows of text and

numbers.

I would like to find out the dollar total of the numbers only, BEFORE i

start formatting the data (text to columns, etc). Because the dollar total

will be in the the millions I would like to have a reference dollar total so

that I know if I have made a mistake at anytime i.e. accidentally delete a

row.

Is it possible to find a sum first?

Any help is greatly appreciated

Trina

numbers.

I would like to find out the dollar total of the numbers only, BEFORE i

start formatting the data (text to columns, etc). Because the dollar total

will be in the the millions I would like to have a reference dollar total so

that I know if I have made a mistake at anytime i.e. accidentally delete a

row.

Is it possible to find a sum first?

Any help is greatly appreciated

Trina

- Seperate Words and Number
- Counting Names in one column if the adjacent column contains a specific number
- Transpose words and numbers into array of different proportions
- Counting if two columns contain the same numbers
- Problems Auto Summing columns that are missing data
- Column Has Text and Numbers, Need To SUMIF Only Numbers
- Sum column containing both text and numbers
- Sum column containing both text and numbers
- Auto Sum for Rows and Column & Merge Cells in a row
- Summing and searching with words and numbers in different columns
- Auto sum data in rows by account number
- Deleting blanks from coloumns that contain data and numbers
- Rounding a column with letters and Numbers
- Sorting numbers and numbers that contain text in excel
- Macro to auto-populate columns D, E and F based on criteria in Colums A, B and C
- Sum columns based on fixed number
- Macro to count # of data rows (excl title & Auto-sum row @ btm) and put result in L2.
- Missing words and numbers
- Search for and extract word from a cell
- Summing cells with text and numbers
- How to combine columns D-Y in Column Z seperated by Numbers
- Auto fill column with numeric and alpha (PA6.a, PA6.b, etc)
- Countif using Wildcard * and number 1
- Countif using Wildcard * and number 1

example :

19yo or 19 years old

How to separate them?

19 and yo?

For example I'm looking for a formula that would tell me how many names contain the number "1" next to it.

1 -> John

1 -> Frank

1 -> Mary

2 -> Mr. Ed

3 -> Tony

1 -> Megan

3 -> Christa

3 -> Jacob

The formula should result in "4" which correlates to the amount of names that have the number 1 next to it. Please help me out. Eventually I want to utilize it in a google documents spreadsheet. Is there any reason it wouldn't work in google docs but will work in Excel? I have tried using any array formula but I'm not getting the results I'm looking for.

answers to lazy partiers and try this fun problem. I dreamed part of

it last nicht.

How do I transpose an array of words and numbers into an array of

different proportions?

The proportions of the arrays can be anything, including n x 1 and 1 x

n.

The size of the array can be anything that fits on a worksheet and can

be located anywhere on the worksheet.

Ex:

Array of the present (4x5)

ab 12 de 1.55 ghe

ef 34 nu 3.65 unt

gh 56 mc 2.45 wen

kl 78 vm 1.35 rep

After a re-arrange (7x3)

ab 12 de 1.55 ghe ef 34

nu 3.65 unt gh 56 mc 2.45

wen kl 78 vm 1.35 rep

I am uncomfortable with VBA so don't use VBA.

I don't want to copy/paste because I want the second array to update

immediately when I change the values in the first array.

Also another reason I don't want to use VBA is I would necessitate to

run it after every update.

Thank you and have a good evening,

Manfred Straub

(originally from east Zurich)

number in the first column I want to count how many in the second column

contain the same number.

Thanks

With ActiveWorkbook.Worksheets("sheet1") FinalRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 15 To 18 Cells(FinalRow + 1, i) = Application.WorksheetFunction.Sum(Cells(1, i), Cells(FinalRow, i)) Next End WithBecause of this strange issue i decided to try working around by inserting a formula into the final row of column i instead. This throws an error object variable or with block variable not set.

To recap, I need code to auto sum columns of variable height that may also be missing data in certain rows.

Sub Macro4() 'autosumming columns FinalRow = Cells(Rows.Count, 1).End(xlUp).Row With ActiveWorkbook.Worksheets("sheet1") For i = 7 To 9 Cells(FinalRow + 1, i).Select Selection.FormulaR1C1 = "=SUM(R[1]C[i]:R[" & FinalRow & "]C[i])" Next End With

Thank you for your help.

The text and numbers appear in this column as the result of an if formula (if

value returned > 0, "-", [value]). Can I sum a column containing mixed

information?

The text and numbers appear in this column as the result of an if formula (if

value returned > 0, "-", [value]). Can I sum a column containing mixed

information?

I am looking for a macro that does the following:

Auto Sum for each row and store in the "total"Auto sum contents of column "total" and store next to "augtotal"Merge the columns and automatically insert the text "Incidents Opened In September"Add Color "Light Yellow according to the Sample image"

The sample image contains the screen shot of the output

cheers

sravanthi

column A column B

60 house

120 car

30 misc

52.25 food

83.33 gas house 180.25

120.25 house car 120

25 misc misc 55

105 food food 157.25

50.5 gas gas 133.83

any help i can get would be appreciated, even if it can't be done i've attached a file if this doesn't come through well

Thanks!!!!

Dim intCol As Integer

For intCol = 44 to 59

Range(Cells(, intCol), Cells(487, intCol)).SpecialCells(xlCellTypeBlanks).Delete Shift:=xlUp

Next intCol

End Sub

The only problem is that the blanks in the coloumns of the text are removed but the ones containing the coloumns of numbers remain unchanged.

Thanks to all

First, let me tell you how the spreadsheet is set up.

Column A is Empty

Column B has Item Numbers in it

Column C has Description

Column D has Pack/Size

Column E has Barcode

Column F has Weekly Average Bought

Column G has Base Amount

Columns F&G are carried out to 2 decimal places

I need something that says the following;

If F+G=0 then change to “Z” if not then leave F & G as is

Then I need,

If F

by text (e.g., row 1: 1000, row 2: 1500; row 3: 1000a; row 4: 1500a)

Identical numbers are related documents, with the text suffixes referring to

addenda documents; thus, document 1000 has an addendum document 1000a; How

can I sort the column so in the following order: row 1 (1000), row 3 (1000a),

row 2 (1500), row 4 (1500a)?

Thank you

--

MZ

My challenge is that I have a spreadsheet with six columns. Columns A, B and C will be populated with either 0 or a number greater than 0. What I am trying to do, with no success is, if the number in columns A, B or C = 0, have the adjacent cells in columns in D, E and F auto-populate with "Not Applicable" and if the number is greater than zero, have the adjacent cells in columns D and E auto-populate with "Please Complete" and column F auto-populate with "Outstanding". I am self-taught with respect to macros and as such, my knowledge is sketchy at best.

Any suggestions or even re-direction would be much appreciated.

Thanks -

Cindy

I have a 12 column (12 month) with numbers. In one field I write one number for example 5.

If I write number 5 I want to SUM first 5 column (from A to E).

Imran,

Is there a way to count the total number of rows with data (excluding title row at top and Auto-Sum row at bottom) and put the result in L2?

Thanks much

I have a problem, I recieved a huge list of numbers on my email, and my boss said I have to put them in Microsoft Excel and find out which ones are missing. (list shown here:bit.ly/jflBZ8) File is attached below.

String contains one word and three numbers e.g. A582, U821,...

Anyone knows a function for this?

Thank you!

Best,

Example:

Cell contains the string "Happy New Year 2008 Be safe and have fun 03010"

How would I pull out the word "Year" and put it into the next column and leave everything else in the cell?

Thanks!

the type of time off time off taken. Unfortunately since the cells

contain both text and numbers I haven't figured out how to set up the

formula - can anyone help?

For example - I took 8hrs of vacation on 1/1/06, 2 hours of vacation on

1/2/06, 3 hours of sick time on 1/3/06 and 4 hours of sick time on

1/4/06. I am using "V" to signify vacation & "S" to signify sick time

so the cells would be 8V, 2V, 3S & 4S. My excel sheet would show the

dates 1/1/06 to 1/4/06 in cells A1 to D1. My time off would show in

cells A2 to D2. Then I tried to use cell E2 to sum up the vacation time

& F2 to sum up the sick time. Basically I want it to tell me that I

have used 10 hours of vacation & 7 hours of sick time.

I tried to put an example below...

A B C D E F

1 1/1 1/2 1/3 1/4

2 8V 2V 3S 4S

Any help that someone could offer would be greatly appreciated!

How can i merge all the columns from Column D to Column Y in Column Z. The seperator between the Columncontents should be numbers in format "<<1>>" for column D, "<<2>>" for column E,"<<2>>" for column F........

i have a wordlist(arabic from right to left lanuage) containing words and meanings. Column A contains Words, Colulmn B contains Transcription, Column C contains Grammer information and the following Columns up to Column Y contain of Meanings.

!!!The meanings start with Column D which is then followed by E,F,G... Y. If any column cell is empty then it would mean, that the following cells of corresponding columns are also empty. For example if Colulmn D has content but Column E not, then it means that F,G,H...Y are also empty !!

Thanks for each assistance in Advance

Example attached excel file:

Is there a way to auto fill a column with numeric and alpha...

PA6.a

PA6.b

PA6.c

Thanks,

Steve

example the column could look like this:

a,1

1

1

b,1

b

a

What I want to do is count all the times that 1 shows up. When I try

to use formula =COUNTIF(I508:I512,"=*1*") It doesn't count the

instances where 1 is all by itself. It only counts 1 when it is with

another letter.

What I've resorted to is a forumula that looks like this.

=SUM(COUNTIF(G2:G431,"=1"),COUNTIF(G2:G431,"*1"),C OUNTIF(G2:G431,"=1*"))

Basically it has all the possible options and then adds them together.

But why doesn't the wildcard feature work?

thanks, mike

--

southdaytona

------------------------------------------------------------------------

southdaytona's Profile: http://www.excelforum.com/member.php...o&userid=28529

View this thread: http://www.excelforum.com/showthread...hreadid=481830

a,1

1

1

b,1

b

a

What I want to do is count all the times that 1 shows up. When I try to use formula =COUNTIF(I508:I512,"=*1*") It doesn't count the instances where 1 is all by itself. It only counts 1 when it is with another letter.

What I've resorted to is a forumula that looks like this.

=SUM(COUNTIF(G2:G431,"=1"),COUNTIF(G2:G431,"*1"),COUNTIF(G2:G431,"=1*"))

Basically it has all the possible options and then adds them together. But why doesn't the wildcard feature work?

thanks, mike

No luck finding an answer? You could always try Google.