|
|
Sum(indirect(Address...... by
Kevin Smith[_2_]
Hello,
I am trying to produce a formula that will give the last 4 weeks average
from a Row that contains the daily figures followed by the weely averages...
|
|
3 |
120 |
|
|
|
Vlookup to the left ? by
Eric_in_EVV[_2_]
I have a spreadsheet that looks like this:
1/1/09 blank
1/2/09 DISC
1/3/09 blank
1/4/09 blank
1/5/09 blank
1/6/09 ...
|
December 2nd, 2009 09:15 AM
by Pete_UK 
|
8 |
97 |
|
|
|
IF Function by
Gerard Sanchez
Can anyone help me get this to work?
=IF(AND(COUNT(C20:C53,F20:F53,I20:I53)0,IF(ISNUMBER(H51,A54,D54,G54))),SUM(B20:B53,E20:E53,H20:H51)/2,"NOT
BALANCED...
|
|
3 |
92 |
|
|
|
trying to use Indirect function by
Eric_in_EVV[_2_]
I have a formula in cell G2 of a worksheet called "Departmental Summary"
Column A of the same workbook contains employee names and there is a separate...
|
|
0 |
90 |
|
|
|
consective numbering by
Richard
I use an excel spreadsheet to do monthly invoicing and would like to be able
to consectively have a invoice number each time I prepare a new invoice. Is
this...
|
|
1 |
131 |
|
|
More Than VLOOKUP() by
Gary''s Student
I need to be able to lookup values in a table that may include errors. For
example in A1 thru B9 I...
( 1 2)
|
December 2nd, 2009 03:14 AM
by minyeh
|
11 |
169 |
|
|
|
BLANK cell as a result of IF condition by
Vlado Sveda
I'm trying to find a way how to use IF condition:
=IF(MyCondition; ValueIfTrue; ... else leave cell empty ...).
=IF(MyCondition; ValueIfTrue; "") is not good...
|
December 2nd, 2009 02:37 AM
by minyeh
|
4 |
93 |
|
|
|
|
|
1 |
109 |
|
|
|
|
December 2nd, 2009 02:11 AM
by mishak
|
1 |
97 |
|
|
|
Sum (throw out highest and lowest) by
Timothy Garrison
I am working on a contest scoring sheet for the California State Old Time fiddlers Association and it is contest policy to throw out the highest score and the...
|
December 2nd, 2009 02:09 AM
by minyeh
|
3 |
154 |
|
|
|
|
|
1 |
92 |
|
|
|
Conditional format SUMPRODUCT by
Arizona
I am trying to create a simple conditional format in a cell to multiply the
cell value if it is greater than 0 by a value in another column.
I have tried...
|
|
3 |
85 |
|
|
|
Count if or SumProduct by
Brandy
I have two columns : column A defines the make/model; column B numerically
defines how many were sold . Note: There are multiple entries for the same...
|
|
2 |
86 |
|
|
|
SumIf Formula by
SimonM
Hi,
I'm trying to find the appropriate formula for my needs. I need a formula
like SumIf, but the logical test only picks up bits of the text in a cell,
not...
|
|
2 |
87 |
|
|
|
Adding numerals with moving decimals by
Loadmaster
Cells U2:AC2 have 1000-9000 lbs. Cells S3:S14 have Compartments B thru M
Cells U3:AC3 have the following figures corresponding the weights above.
7.3 for 1000...
|
|
2 |
110 |
|
|
|
Counting coloured cells? by
Atomic
I'd like to know how we can count coloured cells?
i.e
If cells A1 C1 E1 F1 and G1 are coloured, I’d like to know how I can see the
total coloured cells in...
|
December 1st, 2009 10:25 PM
by JLatham
|
2 |
125 |
|
|
|
|
December 1st, 2009 10:24 PM
by JLatham
|
3 |
94 |
|
|
|
Embed a 'match' statement in sumproduct? by
ker_01
Excel 2007
I'm trying to help a coworker who wants to generate a few summary pieces of
data (like a pivot table, but for only a few categories). The raw data...
|
December 1st, 2009 10:01 PM
by ker_01
|
3 |
84 |
|
|
|
Notepad or .txt file to excel by
nathan
I have a notepad file with thousands of rows of information. I want to copy
it to excel. It copies very well each line into separate rows. But......I...
|
|
3 |
104 |
|
|
|
if meets criteria add 1 by
r2rcode
i need a formula that will look at a text/number in a column and go down the
column and add 1 to get a total number of items meeting the...
|
December 1st, 2009 09:38 PM
by JLatham
|
2 |
79 |
