ExcelBanter

using the countif function

harrimanxix — Tue, 13 May 2008 22:23:01 GMT

Hi All
im using the countif function to add up all the cells in a range that
contain the Letter D the formula works but the problem im having is that if
there is on D in the range then the formula returns the 0 (zero) value how do
i get it to just leave the cell blank ??? ps ive tries addin ,"") this does
not work

cheers guys or gals

Adding like rows

roadworthy@gmail.com — Tue, 13 May 2008 22:14:37 GMT

I use Excel 2003. I have a 100 row spreadsheet with 3 columns:
Amount, Value A & Value B. What is the easiest way to create a second
3 column spreadsheet where each row is unique Value A - Value B
combination and the 3rd column is the total of every amount in the
original spreadsheet with that particular A-B value.

To illustrate with a simple example, if I start with:

$500 10 265
$200 10 265
$100 20 300
$300 20 300

I want this result:

$700 10 265
$400 20 300

Thanks very much,
Dave

End if without Block If

Carrie_Loos via OfficeKB.com — Tue, 13 May 2008 22:14:22 GMT

I think I am trying to do too much in one line but I am not sure how to write
it correctly. I want the user to be able to click on cell P1 and then a
message box ask if they have completed the input - If yes, then save the file
name and date, if no then end sub. I am getting the error message above and
can't figure it out. Can anyone help?

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Dim ans As Long

If Target.Address = Range("p1").Address Then ans = MsgBox("Are you
finished inputing Daily Info?", vbYesNo)
If ans = vbNo Then ActiveWorkbook.SaveAs Filename:=Range("A1").Value &
Format(Worksheets("Daily").Range("ax1").Value, "yyyy-mm-dd") & ".xls"

End If
End Sub

Thanks
Carrie

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200805/1

Saving as CSV File

Steve Wade — Tue, 13 May 2008 22:14:00 GMT

I am attempting to save a worksheet as a CSV or TXT file to import into
another program. When I attempt to save as the nly file options presented are
xls or all file types. I save the file with a csv extension.

When I attempt to import the file it is not recognized as a CSV. Save thing
when I save as txt.

Am I missing something. Using Excel 2003 SP#.

Note we are also integrated with Hummingbird DM5 (OPEN TEXT)

how do i find what cells equal a certain number?

tdub — Tue, 13 May 2008 22:12:00 GMT

I have a string of dollar amounts and I am trying to see if there is a quick
way to find out what amounts will total a fixed number. For example, I have
a number of cells, and I want to see what cells will total $500,000.00

Custom Format as Currency with If/Then ($1B or $500M)

bkdelong@pobox.com — Tue, 13 May 2008 22:07:01 GMT

Trying to get a column to auto-format numbers based on value - I've
done some Google searching, checked through newsgroup archives and
must be looking in the wrong place.

I have a variety of numbers from $146.0B to $.0093B using a Custom
Format of $#.0####,,,"B". Ideally, the "$.0093B" should be rendering
as $9.3M but I'm not sure how to do an if/then statement or some sort
of tweak to allow this to happen.

Is this even possible or should I do everything in millions?

Adding 1 everytime something is in a column

Learning Excel — Tue, 13 May 2008 22:02:01 GMT

I have an empty column that I fill with numbers that could be 2, 30, etc.
( from A1 to A40). In A41 I like to have a total of cells with numbers on it
( not the sum ), in other words, A41=total of cells filled from A1 to A40.
Thanks in advance for the formula ( no VBA please ).
--
Socrates said: I only know, I don''''''''t know nothing.
I say : I don''''''''t even know, I don''''''''t
know nothing.

Disappearing Drop-down Box in Excel

Bill — Tue, 13 May 2008 21:56:02 GMT

want to create a drop-down list in Excel that removes the entry once it is
used. That is, the entries that have not been used remain viewable and
available to the user, those that have been used are not shown in the list.

Anyone ever done this in Excel?

Excel 2007 - Nothing shows up in the cell while I'm typing!

TomO — Tue, 13 May 2008 21:53:00 GMT

I'm running into an issue with a range of cells in a spreadsheet where
nothing shows up in the cell as I type. I can see the cursor moving
to the right to show that I'm typing something, but the value that I'm
typing doesn't actually appear in the cell until I hit .

I'm maintaining a large workbook with lots of formulas and named
ranges. It was built by someone who no longer works here, so I'd
rather not blow it away and start over. It appears it was built using
Excel 2003. I'm now managing the file in Excel 2007. I've been
adding records to this spreadsheet for several days now and didn't
have this issue. But now all of a sudden, I get to a certain row (in
this case, Row 1776) and nothing I type shows up until I hit enter.
If I clear the contents of any row above row 1776, I can clearly see
everything as I type it. But with Row 1776 and beyone, I can't see
what I type.

I am able to see what I'm typing in the formula bar at the top of the
page, but not in the cell itself.

Any help would be greatly appreciated!

can I take info in rows to another sheet as row headings?

Lukengruven — Tue, 13 May 2008 21:44:02 GMT

I have colum headings project #, discription, location, year, budgeted.
30-40 different projects filled out in the rows.

Can I get excel to take the info on each project, (#, discription, location,
year, budgeted), to another sheet? Such as if I have a template sheet that I
would like the info inserted into, and linked to, so that I have a sheet on
each project in my spreadsheet.

Thanks

Excel File exported from Quickbooks does'nt register numbers as nu

skoo — Tue, 13 May 2008 21:40:00 GMT

Hello,

I am exporting a report from Quickbooks Point of Sale Pro 5.0 to Excel 2000
and trying to create a "sum of" calculation. The sum always comes to 0. It
is not registering the numbers as a number. However, if I do not use the
"sum of" button, and just put + (plus sign) and click each cell, it will add
the cells correctly. I have tried to use the Format Cells option but cannot
find a way to correct this problem. I have also noticed that when I go to
save it tells me that it is not the most recent version of Excel. I have
tried choosing to save to the most recent version or not and it doesn't make
a difference. I would love to be able to use the "sum of" button because I
am adding a great number of cells. Any suggestions would be greatly
appreciated.

How do I sort A1 THROUGH F26 alphabetically?

Meer — Tue, 13 May 2008 21:33:02 GMT

I have columns A through F. Each column has 26 rows with inventory items
(text). When I try to sort it, it sorts BY column A and the other columns
remain unsorted. Apparently, I can only sort each column separately but I
need the items in ALL of the columns to be sorted together.

Is there a way to do this?

BTW, I'm using Excel 2007.

SumIF-multiple conditions/OR

GaryW — Tue, 13 May 2008 21:24:00 GMT

I have a range of cells that I want to ck for a "Y", then in the next range
can be "STOP" or a value of "Go"? Kinda a mix of conditions.

ABC Inventory Classification

Richard — Tue, 13 May 2008 21:20:00 GMT

I have spreadsheet with YTD sales for approx. 1,000 parts and need to know
which items are the most important. Basically I need an ABC report which
will tell me what parts make up 80%, 15% and 5% of the total Revenue and
assign a letter of A, B, or C respectively. Is this possible in Excel? If
so how would I do it?

Thank you,

Mutiple Spread Sheets

ABA — Tue, 13 May 2008 21:10:00 GMT

I Have a mutiple Spreadsheets with several functions caring over to each one.
I want to set a fucntion that only shows greater then 0 amounts on the last
spread sheet. I tried a filter but need to edit it so that any time a dollar
amount is added to spreadsheet 1 it shows up on spreadsheet 4. It needs to
be able to only pull dollar amounts great then 0 from the previous 3
worksheets. Is there a function I can use Besides the the filter? I need
to save it so other users in my company can come in and in put data without
having to "manually use the filter" I need a function to set this up.
PLEASE HELP!
--
ABA