|
|
formulas by
teresa
Hi, i have a formula here that doesn't work
=SUM(IF((TB!$B$2:$B$4133=$A2)*(TB!$D$2:$D$4133="M"),TB!$I$2:$I$4133))
What i was after is to get the total in the...
|
November 7th, 2007 12:19 AM
by Pete_UK
|
1 |
55 |
|
|
|
|
2 |
89 |
|
|
If formula by
kanstrup
Hello,
I have a formula here and I don't understand why it doesn't work. The
situation is such. I have a cell A1 that has a specfic date in it. If this...
|
|
3 |
51 |
|
|
Look up data on the next line by
Matheus
Hi, I've got the following information on a spreasheet:
A B C
1 Asia Measurement 0.64
2 Goal 2.0
The Cell...
|
|
2 |
60 |
|
|
Date Formulas by
JF
I want to create a sheet that I can collate data gathered from the net for
release dates of books, dvd's etc... I will not be doing this on a regular...
|
November 6th, 2007 11:29 PM
by JP[_4_]
|
1 |
48 |
|
|
change background color in cells by
Joe
I would like to change the backgound color of a cell to yellow, based on the
value of that cell being greater than 60. This should apply to all cells in a...
|
November 6th, 2007 11:20 PM
by Joe
|
4 |
50 |
|
|
|
November 6th, 2007 11:11 PM
by JP[_4_]
|
1 |
57 |
|
|
Lookup data based on data comparison by
Dan
Newbie he
I would like to select a column (A1:L1) based on the data in cell M1. My
data range is A2:L20. The data in A1:L1 starts w/1000 and steps up 500...
|
November 6th, 2007 10:52 PM
by Pete_UK
|
7 |
97 |
|
|
|
November 6th, 2007 10:49 PM
by Pete_UK
|
5 |
72 |
|
|
Increase amount to achieve target by
pkeegs
I want to increase an amount ($1,000) over a number of periods (52 weeks) so
that it will achieve a 40% increase at the end to $1,400. I would like a
formula...
|
|
3 |
67 |
|
|
Summing up range of data by
Krish
I have 3 columns.
Customer#
Margin $
Average Order size
The table is sorted to show customers with descending Average order size.
I am trying to get the sum of...
|
|
1 |
89 |
|
|
IF STATEMENTS NOT WORKING by
Iguss
I have the following
FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK
FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK
FEDERAL...
|
|
6 |
102 |
|
|
|
|
1 |
87 |
|
|
|
|
3 |
54 |
|
|
|
|
3 |
77 |
|
|
Formula Omits Adjacent Cells by
Excel Hater
I have filters on and I'm using the SUM to add a group of numbers. It seems
that excel automatically adds adjacent cells that I have hidden(I'm guessing...
|
November 6th, 2007 09:15 PM
by MartinW
|
7 |
89 |
|
|
|
November 6th, 2007 09:12 PM
by Susan
|
1 |
91 |
|
|
Cell containgn a date and a text by
Iguss
Can someone please advise, how can I extract a date from a cell which
contains a date and a text.
FEDERAL HOME LN BKS CONS BD 3%0 Callable...
|
|
5 |
91 |
|
|
Rounding up or down in the same formula by
Jack L. Hyman
How do I create a single formula to either round up or down the result of my
formula to the nearest "9"?
i.e.
843 = 839
845 = 849
etc., etc.
Thanks,
Jack
|
|
7 |
54 |
|
|
Referencing Cells on Different Worksheets by
KristinD
I'm making a workbook that has 1 Worksheet which summarizes the data
contained on the other 10 worksheets.
I'm using formulas to reference the value on the 10...
|
|
2 |
98 |