|
|
formula by
Help with cell function[_2_]
I need to know if I can get a formula for the following:
If cell E14 is "y" and G14 is less than or equal to 14 the H14 should be "y"
|
|
4 |
135 |
|
|
Autofill reference series by
Rick
How can I make the following cell reference drag and fill up to B66
='F20 survey'!$B7
='F20 survey'!$B8
='F20 survey'!$B9
....
='F20 survey'!$B66
When I...
|
August 18th, 2009 04:31 PM
by Rick
|
3 |
126 |
|
|
|
|
3 |
116 |
|
|
sumif? by
mits
Ar Bs Ec Ar Bs Ec
20 36 14 10 7
I am trying to sum the above columns. Column 1-3 supercede columns 4-6, in
the sense that if column 4 has a figure in there...
|
August 18th, 2009 03:40 PM
by Luke M
|
6 |
132 |
|
|
Function Problem by
Scp
Well, I'll start it to what I have so far, but I need one last improvement to
the formula to make it true, and I keep getting...
|
August 18th, 2009 03:35 PM
by Luke M
|
4 |
113 |
|
|
#NAME Error message by
MJ
I have a client using Excel 95 and when he open my workbook - Excel 2007 he
gets the error message #NAME, can anyone help with this problem.
Campatibility...
|
August 18th, 2009 02:59 PM
by Luke M
|
1 |
132 |
|
|
Sum Product based on value by
Mindy
Hi,
I am trying to sum the number of divisions based on work area category. If
work area category (K6:K169) is 1, then count division number (column...
|
August 18th, 2009 02:58 PM
by Eduardo
|
2 |
97 |
|
|
counting entries by
mits
Ar Bs Ec Ar Bs Ec
B A C B B
I am trying to count entries for the data above. The 1st 3 columns are equal
to 1 entry each, and the last 3 columns are equal...
|
August 18th, 2009 02:11 PM
by mits
|
4 |
109 |
|
|
|
|
5 |
105 |
|
|
Adding based on multiple criteria by
Custard Tart
My spreadsheet has two colums side by side.
Column A: contains letters such as GM, GMA, GMQ etc.
Column B: contains complete, partial,...
|
August 18th, 2009 02:03 PM
by Luke M
|
5 |
91 |
|
|
|
August 18th, 2009 01:54 PM
by Luke M
|
2 |
96 |
|
|
Fractions by
jct6641
When converting a decimal to a fraction, I get some responses like 1/67 when
what I am looking for is increments of 1/64. Then I want to display 10/64 as...
( 1 2)
|
|
15 |
183 |
|
|
Help by
b46ygurl
Is it possible to link two cells (that has the same information) and when you
update one it automatically updates the other?
|
|
2 |
83 |
|
|
|
August 18th, 2009 10:47 AM
by Pete_UK
|
1 |
94 |
|
|
Speed of array formula by
Cresta
Hello All
I have several sheets with a high column and row count, and takes about 3
minutes to calculate. Each sheet has a column of unique numbers for...
|
|
1 |
104 |
|
|
|
|
1 |
127 |
|
|
|
|
1 |
82 |
|
|
Question about Sum by
Keith
Hello,
In the formula =sum(B6:B50) is there any to make the value represented
here by the “6” a variable? Is there any I could point it to, say, the...
|
|
2 |
88 |
|
|
what group for "bug" finds by
OutsideObserver
Hey, I found a stupidity bug (yes it was stupid to have missed it).
When you detail a hyperlink, all is fine. When you format the
hyperlink, all is fine.
...
|
|
7 |
119 |
|
|
Subtotals in a Pivot Table by
Ashley1432
I have a pivot table that sums the activity of different items throughout
different months. Many times an amount will come in as a positive amount and
then...
|
|
1 |
168 |