|
|
|
|
10 |
194 |
|
|
How can perform a summation? by
Leebo
Is there a way to perform a summation expression in Excel?
For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use...
|
August 23rd, 2005 04:38 PM
by RagDyeR
|
5 |
194 |
|
|
Excel Idiot Needs Formula Help!! by
Donna123
I posted earlier as a Novice, but have since reduced myself to idiot
status. Working on our budget for 2006, which up to now is largely a
manual process. We...
|
September 5th, 2005 05:28 AM
by peto
|
1 |
194 |
|
|
|
|
5 |
194 |
|
|
|
October 5th, 2005 05:55 PM
by Frank3
|
2 |
194 |
|
|
|
October 14th, 2005 07:48 AM
by Biff
|
3 |
194 |
|
|
Editing an existing formula by
Jen
I have a small but frustrating problem with an excel formula. I have a
formula that is adding a bunch of cells (cells are not in a range). The
original...
|
October 24th, 2005 07:55 PM
by Biff
|
1 |
194 |
|
|
|
November 12th, 2005 12:19 AM
by Max
|
11 |
194 |
|
|
How do I enter formula for or numbers. by
Betty P.
I am trying to enter a formula in a worksheet. I want the formula to do the
following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter
2,...
|
November 27th, 2005 06:25 PM
by Betty P.
|
7 |
194 |
|
|
Pivot Table - Average of counts by
Dan in NY
Reposting...
I have a table with 3 columns of text where column A maps to multiple values
in col B which maps to multiple values in col C.
e.g.
X Y Z
X ...
|
|
0 |
194 |
|
|
conditional sum question by
Devlin
Hello,
I want to add a range of values, but they are formatted differently:
some of them are formatted with the dollar currency, others with the
euro...
|
August 17th, 2005 07:27 AM
by Devlin
|
6 |
194 |
|
|
|
|
13 |
194 |
|
|
Transferring info between worksheets by
Boenerge
Is it possible to transfer data between worksheets within the same workbook.
E.g. if I wanted to track holidays and have the dates entered into...
|
|
0 |
194 |
|
|
|
May 25th, 2005 07:24 PM
by simora
|
0 |
194 |
|
|
random number results by
mcmil
i have random numbers generating from 1-100 on the same number of cells
(h:1-h:100). what i would like to do is see how many times a number comes up
in those...
|
|
5 |
194 |
|
|
SUMIF over multiple columns by
psmith4497
is doing a SUMIF over multiple columns not allowed?
This formula works =SUMIF(C:C,J5,E:E)
but this does not: ...
|
June 17th, 2005 06:40 PM
by bj
|
3 |
194 |
|
|
Get aveages for last few days by
Sick Puppy
I am making a new spreadsheet to record daily blood pressure readings. Each
day's readings go into a row below the previous day's readings. I can...
( 1 2)
|
June 23rd, 2005 06:06 PM
by Domenic
|
15 |
194 |
|
|
|
June 23rd, 2005 07:48 PM
by Liz C
|
2 |
194 |
|
|
Autofill by
sisco98
Hi all,
I would like to use autofill in a macro, but the length of the range is
changing every time when I open the workbook.
The task would be that when I...
|
|
1 |
194 |
|
|
Add protect worksheet password in macro by
Kelly
I created 43 sets of workbooks that need to be locked and protected from end
users. I have created a macro that will clear the previos days numbers and
copies...
|
January 10th, 2006 02:08 AM
by Paul B
|
1 |
194 |