|
|
|
|
5 |
74 |
|
|
|
|
10 |
109 |
|
|
Sumproduct Help by
AndyO_UK
Hi
Currently I have the following string setup:
=SUMPRODUCT(--('Awaiting Further Info'!B2:B294="NU"),--('Awaiting Further
Info'!F2:F294="D"),'Awaiting...
|
|
4 |
83 |
|
|
Sumif query by
AndyO_UK
I need help with the following:
I need to search column A for all instances of "N1", in column F is the
value for that row.....
....what can I use to get...
|
|
4 |
74 |
|
|
Date Calculation by
AndyO_UK
I need help with the following:
Column 'I' contains Annual Rental
Column 'M' contains Date Ceased
My end of financial year is 31 March 2007
I need to...
|
|
2 |
77 |
|
|
Sum or Countif over Multiple Columns by
AndyO_UK
Hi
Currently I am using Sumproduct to count column B "NU" and column F "D" but
now I also need it to look at column I (which contains the value for that
row)...
|
|
3 |
80 |
|
|
Cell Protection by
andyp
Hi
When protecting a selection of cells in a workbook
(Format cells -locked) then password protect worksheet,
the cells that are not locked allow text...
|
March 17th, 2004 05:01 PM
by VWP
|
2 |
107 |
|
|
|
|
2 |
113 |
|
|
Help!! with a formula by
Andyp
I need to attribute 10 points for every £1000 revenue achieved. So for
example £1800 would be 10 points, 5760 would be 50 points etc. If I have
column A with...
|
August 25th, 2005 09:35 AM
by Andyp
|
3 |
66 |
|
|
|
|
3 |
82 |
|
|
Excel IF/LARGE Function problem by
andyp161
An incentive scheme at work allocates points to employees and the three
highest earners per week receive bonus points. Therefore, I want excel
to locate the...
( 1 2 3 ... Last Page)
|
July 26th, 2004 08:13 PM
by hgrove
|
50 |
2,181 |
|
|
Excel MATCH Function problem by
andyp161
Is it possible, when using the MATCH function, to find all matches
rather than only the first match when using '0'?
---
Message posted from...
|
|
5 |
133 |
|
|
PERCENTILE Problem?? by
andyp161
Is it possible using the PERCENTILE function to select the middle 90% of
an array for analysis therefore discarding the top 5% and bottom 5%.
I have a...
|
|
2 |
163 |
|
|
SUMIF Variations Problem by
andyp161
Hi there,
I would like to develop variations of the SUMIF function. For example,
in Column A are the names of consultants (Bob, Jim, Bill etc)and in
Column B...
|
September 13th, 2004 03:19 PM
by JulieD
|
4 |
206 |
|
|
|
September 18th, 2004 01:48 PM
by andyp161
|
0 |
77 |
|
|
IF Problem by
andyp161
I am simply trying to link cells in different worksheets using SUM.
However, if a cell is empty, SUM returns a 0 but I want it to return as
empty. The formula...
|
|
3 |
65 |
|
|
Sort Problem by
andyp161
Is is possible to sort a table according to the date of say A or B
(rather than A then B) so that a table is essentially sorted by the the
earliest date in 2...
|
|
1 |
68 |
|
|
Update Links problem by
andyp161
I have a spreadsheet that is linked to another spreadsheet using...
|
|
1 |
205 |
|
|
Sum Product Problem by
andyp161
Hope you can help!!
Column A=dates eg 17/06/05 etc
Column B=Product eg A, B, C, D, E etc
Column C=Quantity eg 1, 2, 3, 4, 5 etc
Using SUMPRODUCT I am trying...
|
|
4 |
78 |
|
|
#VALUE! Problem by
andyp161
Using the below formula, #VALUE! is returned:
=SUMPRODUCT(--(MONTH(Log!$A$2:$A$200)=MONTH(Stats!$D1)),--(Log!$D$2:$D$200=(Stats!$A3)))
I think it is because...
|
June 30th, 2005 04:02 PM
by Domenic
|
5 |
93 |