How do I sum dollars in one column based on dates in another?
How can I sum the total numbers contained in one column based on dates in
Example: I need the total of 5 units sold int the month of January 2006. I
have the sale ammounts in one column and the closing dates in another.
What forumla would I use for this?
Thanks in advance for any help.
change 1 in the month part to a different month
Northwest Excel Solutions
(remove ^^ from email address)
"Alan" <Alan@discus...Consolidate or Combine Columns
Let's say you have two data sets, each with two columns.
The first column in each data set is an ID#. In the
first data set the second column is "height" and in the
second data set the second column is "weight"
DATA Set 1 Data Set 2
ID# Height ID# Weight
1 57 1 167
2 60 2 190
3 50 4 122
I want to combine (merge, consolidate) these into one
ID# Height Weight
1 57 167
2 60 190
5 ...inserting a column
I wonder if you can help? I have created a spreadsheet on which I have been
able to insert columns until now. Now when I go to insert a column I get the
"To prevent possible loss of data Excel cannot shif nonblank cells off the
Try to delete or clear the the cells to the right and below your data. Then
select cell A1, and save your workbook to reset the last cell used.
Or, you can move the data to a new location and try again."
However, I have done both of these and I still get the same error message
all cells at the end of the sheet are clear so th...How did I make my column headings become numeric (1 2 3)
You asked in the subject line instead of the message body and you did
"averyemma" <email@example.com> wrote in message
...Multipule outlook profiles
I have 2 mail services profiles (on Outlook 2000) each on
its own MS Exchange server (Exchange 5.5), is it posible
to log onto just one profile and have permissions for both?
Delegate control in one of your profiles to the other and
that should work just fine :-)
>I have 2 mail services profiles (on Outlook 2000) each on
>its own MS Exchange server (Exchange 5.5), is it posible
>to log onto just one profile and have permissions for
...switching rows with columns..is it possible?
I'd like to know if I could swap data from rows and columns:
1 2 3 4
a b c d
without doing too much edit or similar...
I have a huge raw data file that needs to get sorted.
nixis00's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1475
View this thread: http://www.excelforum.com/showthread.php?threadid=26380
you can copy the range & then paste /special - transpose - i would suggest
doing the paste in a new worksheet
...How do I sort multiple columns of of numerical and alphanumerical.
Column 1 Column 2 Column 3 Column 4 Column 5
1 9 09A1 0023 delete
3 11 11D4 1057 revise
I would like to sort first on column 1, then 2, then 3, then 4. When I
tried this, it messed up all the numbers in column 4. Help please
Select all 5 columns then sort by column 1.
Then sort by column 2 as first sort key, column 2 as second, and column 3 as
(replace somewhere in email address with gmail if mailing direct)
"slowmo" <slowmo@discus...Addition of two Column with Condition
I need a formula that calculate two or more column with given
condition, I used SUMIF and DSUM , but it cant worked.
On Feb 21, 4:12=A0am, Tayyab <sheikhtay...@gmail.com> wrote:
> I need a formula that calculate two or more column with given
> condition, I used SUMIF and DSUM , but it cant worked.
Difficult to answer without a specific example. Perhaps one of the
following will help:
...How to make each column of data a new worksheet?
I was hoping somebody could help me with an Excel problem - I am not a very
advanced excel user but I am hoping someone can give me some simplified
Basically I have got an Excel 2007 worksheet with 250 odd columns and I need
to split each column of existing data onto a new worksheet. Column A is
actually my list of headings, so ideally I would like to extract Columns A
and B into one worksheet, then Columns A and C, then Columns A and D etc, all
into new worksheets in the same workbook without having to manually copy and
paste each of them.
I am startin...Chart column width
How do I make a chart column wider in Excel 2003?
You can increase the column width via the Format Series dialog,
Series Options > Gap Width. Reduce gap width value.
If you have skinny columns due to dates as category labels then set the
Axes to Category rather than Time series or Automatic.
Right click chart > Chart Options > Axes.
Andy Pope, Microsoft MVP - Excel
"IanP" <IanP@discussions.microsoft.com> wrote in message
> How do I make a chart column wid...Multipule mailboxes
I have SBS 2000 with exchange 2000
I was setting up a user with a exchange account.
But when trying to connect it said could not find mailbox.
I looked at the exchange mail boxes and could not see one for the user so I
tried adding a mail box again, finally it worked and outlook connected to
but when trying to send and receive mail, it errored on receiving.
I looked again in the exchange mailboxes folder and I saw 2 accounts for the
I don't know how this happed,
both have some mail in them, I don't want to lose,
how do I fix this problem?
Decide which ...Column headings question
I have Excel configured with Column Headings in "numbers" rather than in
How do I change the Column Headings back to letters?
The way the worksheet looks now is:
1 2 3 4 5 ...
Thanks for your help, Mark Flynn
Tools/Options/General - deselect R1C1 reference style
"Mark Flynn" <firstname.lastname@example.org> wrote in message
> I have Excel configured with Column Headings in "numbers" rather than in
> How do I change the Colu...Transpose Large Column to Row
I have a column with about 25,000+ rows in Excel 2007, and need to somehow
get this transposed into a row (so with 25,000+ columns). I have tried to do
this with the TRANSPOSE function using Ctrl-C and using the Paste drop-down
menu and selecting the Transpose option. But I get an error message that the
copy area and paste area are not the same size. I presume this is because I
cannot paste across 25,000+ columns?
Basically, in the end, what I want to have is a list of each cell with a
semicolon after each but am just not sure how to do this. Any suggestions
I have difficulty with Word...
I have a letter with column. This is my document type.
But I would like to cut and paste this one page in other
new document. So when I paste my page (with column in top)
my document became in 2 pages. I can't put my document in
just one page...help me please !
...Filling sliding accross and along columns
Can anybody tell me how can I slide a formula contsinaing a constant
across lines and along columns.
Here is an example
a11 a12 a13
a21 a22 a23
a31 a32 a33
What I would like to have is
a11 a12 a13
a21/a11 a22/a11 a23/a11 : For this I use =CELL/$CELL$XX and slide
a31/a11 a32/a11 a33/a11 : Seems like sliding the previous formula
columns is not working.
just a suggestion for you to play around with and figure the solutio
our for yourself.
for the divisor, try $A$1, $A1, A$1 in order to anchor the cell, th
column, the row respectively.
-...Sum a column of variable length?
I have to build a workbook where columns of data will be cut and pasted into
Tab 1, then the column totals need to appear automatically on Tab 2. The
problem is that the number of rows of data in Tab 1 will be variable and
unpredictable, although the columns will always start in a known row.
I might be able to do it by something like
but is there a more precise way?
Here is one way
=SUM(OFFSET('Tab 1'!I7,,,'Tab 1'!COUNTA(I:I)-'Tab 1'!COUNTA(I1:I6)))
(remove nothere from the email address if mailing direct)
"Br...How do widen columns in a column chart?
I tried the other suggestions posted, but it still doesn't work. I have 5
columns that are pretty narrow and I would like to have them 3x wider with a
very small gap in between the columns. I put the x-axsis to category, but I
still can't widen the columns. I am not sure if the chart being copied from
PowerPoint would make a difference.
> I tried the other suggestions posted, but it still doesn't work. I have 5
> columns that are pretty narrow and I would like to have them 3x wider with a
> very small gap in between the colum...Need to sum up numerous columns in different worksheet into 1
I generate 100-200s .csv files end of each month for my company.
Each of these .csv files have numerous data that I need to sum up for a
(Example: 1.csv have 3 columns with things like, item A, item C, item D etc
and 2.csv have columns with item B, item C and item E... and so on and so on)
I am required to sum up all these 100-200s .csv files and have a total sum
of how many of each items appeared and used by the users.
(Example: item A - total count 100, item B - total count 20.. .etc etc)
Is there a way I could do it without going through each of the .csv files
and counti...How do I rename my columns? (i.e.
Just trying to get specific info at the top of my spreadsheet where (A1, B1,
C1....etc) are. Not sure quite how to do it. Any assistance would be
appreciated. Thanks in advance.
You cannot rename the columns, you can use the first row to enter your names
> Just trying to get specific info at the top of my spreadsheet where (A1, B1,
> C1....etc) are. Not sure quite how to do it. Any assistance would be
> appreciated. Thanks in advance.
Use row 1. If the A1, B1, bother you, Tools - Options - View, hide column
In Excel, I need a macro that will delete a column based on a cell
that will contain a name based on an input box.
See you OTHER post.
"Bernie" <email@example.com> wrote in message
> In Excel, I need a macro that will delete a column based on a cell
> that will contain a name based on an input box.
...Moving multipule sheets into their own workbooks
I have a workbook with many spreadsheets in it for customer pricing, each
customer has a sheet of their own. I need to email each particular sheet as
an attachment to each customer, is there a quick easy way to have each sheet
copied and pasted into its own workbook in one or few easy steps instead of
doing each one separate?
I know I've done this before and can't remember what I did, LOL.
Any help would be appreciated.
Kathy in WI
Try something like this
http://www.rondebruin.nl/mail/folder2/mail5.htm...how to access column 8 in my Range
I want to place "1" in column 8 in every row in my range named
"LegendList". How do I do this?
LegendList(, 8) = "1"
and I tried
.Cells(, 8) = "1"
try this to put the number 1 in each cell
Range("legendlist") = 1
or 8 columns over
Range("legendlist").Offset(, 8) = 1
Microsoft MVP Excel
"rpsmith" <firstname.lastname@example.org> wrot...Column Size
I've been playing around with placing objects in specified
cells. However, I've noticed that the standard column
width is shown as 8.43 (64 pixels) - can you tell me what
this measurement is?
I think the standard row height is in points - why the
Width is dependant on the font.
8.43 denotes that many characters can be displayed in the default Arial
With the display set at 100%, note how many columns are visible on your
Now, <Tools> <Options> <General> tab,
And change the default font to Algerian (right ab...Change measurements for columns etc
Hi Can I change the measurements to cm or inch when I format columns. Thanks,
> Hi Can I change the measurements to cm or inch when I format columns. Thanks,
No, you cannot not
Bernard V Liengme
remove caps from email
"MonB" <MonB@discussions.microsoft.com> wrote in message
> Hi Can I change the measurements to cm or inch when I format columns.
Columns("A").Columnwidth = 13 will...Lookup two columns
I want to compare the contents of two (adjacent) cells in one sheet with two
adjacent cells in another sheet (within one workspace) and if the *pair* of
cells are the same, deliver the value in the cell a few columns along (if
you know what I mean - like lookup but comparing two cells). The cells are
If you are comparing A1-B1 sheet 1 to A1-B1 sheet 2, then
=IF(AND(Sheet1!A1=Sheet2!A1,Sheet1!B1=Sheet2!B1),"They match","no match")
If you have to "lookup" A1-B1 against the whole columns of A and B on
sheet2, then kyou co...