|
|
Ecxel Subtotal by
esutton@wilberforce edu
I have used a spreadsheet from the payroll office and compiled subtotal for
each. example:
pp1 50
pp2 50
pp3 40
total 140
My problem is that the total...
|
|
1 |
129 |
|
|
Problem with SUMPRODUCT by
stevesoul
I have used the SUMPRODUCT to add up how many times each month an project is
updated. The formula works from months Feb through Dec, although for Jan, it...
|
|
2 |
111 |
|
|
|
|
3 |
129 |
|
|
formula by
Roger
I need to create in my grade book a formula that assigns different value to
the number in the cell. example homework column average for a student is 90
but...
|
September 28th, 2008 01:31 AM
by Roger
|
4 |
133 |
|
|
Rounding up to a multiple of 12 by
pettyc
I want to add several columns, subtract several columns and if the result is
gt zero I want to add 1 to it, divide by 2 and then round up to a multiple of...
|
|
2 |
115 |
|
|
How to start a makro by
johnny
When I delete a name in a cell I have made a makro that is doing some
"cleening up". How can I make this makro start when the name is deleted? Or
do I really...
|
September 27th, 2008 11:25 PM
by johnny
|
5 |
123 |
|
|
Function within a cell that has a number by
Té
I have a number in a1 which is 500. Is there a way I can leave the 500 in
place, along with add a formula to that cell as well. I want to add a1+b1,
but I...
( 1 2)
|
|
12 |
201 |
|
|
How do I set Auto Print Area? by
Need Help on axis problem in a chart[_2_]
Hi,
I would like to set auto print area to an worksheet, that changes(# of rows)
for different project.
I have fixed width (number of columns), but length...
|
|
7 |
145 |
|
|
|
|
2 |
114 |
|
|
|
September 27th, 2008 05:16 PM
by Mike H
|
8 |
125 |
|
|
Summarize on 2 variables by
Steve M[_4_]
Hoping someone can help.
I have a spreadsheet containing students from 4 schools, thru cell
2159, sorted by Student-ID (6 digit number) and last name. I...
|
|
4 |
100 |
|
|
|
September 27th, 2008 03:54 PM
by franciz
|
4 |
133 |
|
|
find and move values 0 by
Sojo
I am writing a macro to automate several processes. I have the following
table where column A has positive and negative values and column B is blank.
I...
|
September 27th, 2008 03:02 PM
by IanC
|
6 |
123 |
|
|
Limit returned value by
Patrick C. Simonds
In cell A4 is a 4 digit number in cell A1 I want only the last number
|
September 27th, 2008 02:29 PM
by NoodNutt
|
5 |
135 |
|
|
Running Totals by
Pickup
Hi,
I'm working through a college project using Excel. One of the examples is
to generate a random event (toss of a coin) and then record the number of...
|
September 27th, 2008 01:11 PM
by Pickup
|
5 |
149 |
|
|
Formula Question by
Ben
I work in a school and I need to tally the number of tickets grade levels
earn. What I am stuck on is, I want to tally the tickets earned, but when
they hit...
|
|
2 |
111 |
|
|
VLOOKUP Range by
apb000
Is there a way to have excel look up data that falls BETWEEN two numbers,
i.e. in a range, and return a specified character string? For example, "If
(value)...
|
|
2 |
134 |
|
|
Sum only certain worksheets in Excel by
JLS
Hello-
I have a file with 8 worksheets, each representing a different location. I
need to create a Total worksheet that will allow the user to select how...
|
September 27th, 2008 05:52 AM
by T. Valko
|
4 |
221 |
|
|
Coutnif by
Matt
I need help with a countif statement. I have information like the following:
A B
X 1
Y 1
X 2
X 0
I need to count how many times X in...
|
|
4 |
115 |
|
|
|
|
4 |
131 |