|
|
Counting number of X's in a column by
Susie Harris
I need to sum up the number of "Xs" in a column. I would be extremely
grateful if someone could help me with the formula. I cannot seem to get one
to work. We...
|
|
2 |
155 |
|
|
MINUS SIGNS REMOVAL by
Rebecca
Greetings. I am using EXCEL 2003, and I am still struggling. I have a
column containing numbers, and some of the numbers (after calculations from
previous...
|
|
2 |
204 |
|
|
Getting Started Pane by
Sarge
Is there anyway to keep the Task pane open all the time, so I have access to
the information on it? I know after I start using a workbook and the pane
goes...
|
|
1 |
134 |
|
|
Selection mode problem by
Richard L. Trethewey
I seem to have set Excel 2003 to a particular cell selection mode that I can't
seem to turn off. My cursor is the big plus sign and when I click on any...
|
|
2 |
167 |
|
|
Right justify moved data only part way by
hgopp99
As input, I have a spreadsheet, and I noticed that many of the columns, when
right-justified only moved a portion of the way across the cell. Then I
noticed...
|
|
1 |
134 |
|
|
Hyperlinking pdf files by
Kiwi Girl
Sorry everyone, you've probably seen this before. I'm having difficulty
in hyperlinking pdf files. Some links receive a message 'cannot open
the specified...
|
|
2 |
225 |
|
|
Auto Numbering by
Andy JL
I am using the Office 200 suite and have created an Invoice, however I am
unable to create auto numbering in the invoice - I have tried to do it but
have...
|
|
3 |
270 |
|
|
|
|
1 |
295 |
|
|
Why do some number appear as text? by
Rock
Hi,
I have just exported some data in a table from an sql file to Excel and
have noticed that some of the figures in the column have a small green
triangle...
|
|
2 |
193 |
|
|
|
|
3 |
227 |
|
|
|
November 23rd, 2005 12:49 AM
by HIM
|
0 |
114 |
|
|
Blanks as a condition of a statement by
Stuck on Blanks
How is it possible to do a function based on if a cell is
blank or not. Such as the following for cell a1:
IF b1 is not blank then add b1-c1 else don't do...
|
|
2 |
208 |
|
|
Adding time by
trucker
I want to add time,like a sum.
12:00+12:00+12:00=36:00?
I keep getting a basic time like 12:00. Could you please supply a formula.
Thank you
|
|
1 |
106 |
|
|
Formula for by
Andy JL
Hi.
I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
£8.00 or
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula...
( 1 2 3)
|
|
20 |
453 |
|
|
|
|
1 |
329 |
|
|
|
|
1 |
582 |
|
|
Why wont Solver apper in tools? by
Broken man
I checked the box to load solver, but it will not appear under tools? When I
look in my Add In folder there appears to be no files. Is this why it wont
load?...
|
|
1 |
144 |
|
|
|
November 22nd, 2005 06:27 PM
by mcgradys
|
3 |
261 |
|
|
Counting records within a month by
JoAnn
Hi,
I'm relatively new to Excel ... using 2003 version.
I have a sheet containing items listed by date - Column B - (01/2/05 ...
02/15/05 ... etc) - each item...
|
|
1 |
106 |
|
|
Cell locking trouble by
Jeffery Tyree
I have a spreadsheet that needs to be "locked down" but it is a questionaire
styled sheet. Most of the questions on this sheet use radio button or check
box...
|
|
2 |
110 |