Struggling with formula
I have a spreadsheet withthe following data:
28/08/2008 09/05/2008 HINGE SA28553 8 =A31.10 =A30.77 =A36.16
28/08/2008 09/05/2008 HINGE SA28566 8 =A31.10 =A30.77 =A36.16
20/08/2008 28/08/2008 HINGE SA28389 24 =A31.10 =A30.77 =A318.48
14/08/2008 21/08/2008 HINGE SA28268 12 =A30.00 =A30.00
What I need to see is the total number of units, of which XXX are Free
of Charge between xxxx date
Sorry, but I am struggling and got so far =3DCOUNTIF(J2:J924,"=A30.00")
but struggling with the rest, can anyone help
=SUMPRODUCT((FirstDate<=Date"))...COUNTA, but not formulas returning empty string
I have a column (A) where I have entered a formula
=IF(FromAccessTotalSubs!A3="";"";FromAccessTotalSubs!A3) (the row number
increasing on each row). The idea is to copy the column from another
sheet, and ensure that an empty string is displayed rather than 0 if the
copied cell was blank.
When I try to use =COUNTA(A:A) in another cell to find out how many cell
in the column that contains some information (not empty string..) I finf
that COUNTA return the number of cells that contains the (first)
formula, rather than how many cells displays a value to the ...Trouble with copy and past of formulas in Excel
I got a sheet from one of my collegaes that was causing problems, it
sometimes looses formulas (It looks like a problem with connections
through our network) and you get true untrue name errors, after
refreshing the cell the problem is gone. Now I'm having trouble with
copying formulas, after trying some copy and paste it crashes with dr.
Watson. It seems that there is some timeout problem. More people have
trouble with this with the somewhat larger sheets.
...Formulas inside Pivot Tqables
I just upgraded to Excel 2003 and I can no longer do formulas in pivot tables
(in Excel 2000, Right-click inside a pivot table, the 'formulas', then
'calculated field' or 'calculated item'). There is no "formulas' opein in
...Changing cell from formula to data.
Is there a way to change a cell from a formula (that is returning data) to
the data it is returning. I realy hop it it becuse it would help out a ton.
If you select the cell and copy then edit - pastes special - values on the
cell you will have the value and not the formula. HTH
Sincerely, Michael Colvin
> Is there a way to change a cell from a formula (that is returning data) to
> the data it is returning. I realy hop it it becuse it would help out a ton.
Select the cell(s) contain...Excel formulas 01-06-10
I have a worksheet that we would like to use to calculate price + labor for
work. The price formula has me stumped. I would like to be able to put in the
price in one box and have the formula determine the amount at which to
multiply it by.
Price = 20.00 then the formula would determine how many to multiply it by
(3.25) from the range given below.
Range is 0-2.00 *4
I have the labor formula and then the total is a sum formula. Please help...Countif formula
I'm new here and I hope I'm posting in the right forum. I require help
with a formula that has left me scratching my head for a couple of
I have a column of data cells that lists 3 different options, for
option1 = Good
option2 = Ok
option3 = Bad
i need a formula that will count how many 'Good' entries there are and
to work it out as a percentage of the total number of entries (all 3
I hope that makes sense. If more info is required, please let me know.
Thanks for your time
--------------------------------------------------...Help with Lookup/Sum Formula
I have a spreedsheet with this type of data, for example
Product Group Quantity Size
2812 10 0.75
2812 100 0.75
2812 300 0.5
2817 100 0.25
2817 200 1
2845 1000 1.5
I want to be able to set up a formula that you enter a product grou
(2812) in a cell and it will for that product group go and sum up al
the quantities for each size. The formula would go in the Sum colum
...Need a formula that tags one table based 2 columns in each table
I have two tables on one worksheet, Table A and Table B. Each table
contains two column with X and Y coordinates, all values are numerical. The
coordinate system is irrelevant. I need to "tag" all XY coordinates in
Table B that have a matching XY coordinate in Table A. If Table A
coordinates are in columns A and B, and Table B coordinates are in columns C
and D, then I want to place the text "hit" in column E next to each
coordinate pair from columns C and D that match a coordinate pair in columns
A and B. The ranges for the respective tables have been named ACOORD and...Formulas to highlight cell if condition is met
i wonder if there is any way i can highlight a cell if a condition is
eg i want to highlight the cell if the num in the cell is greater than
1. do i hv tio use macros?
hmmm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25836
View this thread: http://www.excelforum.com/showthread.php?threadid=481784
No you can use conditional formatting
Select the cell
Menu Format>Conditional Formatting
Set to greater than
Set value to 1
Click the Format button
Select the Pattern Tab
...Formula to display Count of Days in given month, using list of Start and End Dates
I have a large number of rows that contain a start date and end date.
I am attempting to generate a count of days within that date range
that are in a particular month, for example, Jan of 2011.
Any suggestions for a formula that could be used to display the
amounts shown in Column C would be helpful.
A B C
Start Date End Date Count of Days in Jan2011
1/10/11 4/7/11 21
2/6/11 3/1/11 0
12/20/10 2/15/11 31
I think the best way is to create a table f...Help With Formula #5
I have data in a worksheet
A B C
1 Verify 2% 99%
2 Audit 2% 98%
3 Account 5% 97%
4 Forward 4% 96%
5 Place 5% 95%
I have another cell (F1) in the sheet that i would like to
list the text in A1, but only if B1 is at least 5% if not
then I want it to list A2, but only if B2 is at least 5%
and so on down to A5. Please Help.
What happens with row 3 and row 5?
"Report Lackey" <email@example.com> wrote in message
news:033b01c3d62d$ebd800e0$a401280a@phx....Excel formula needed or how to
I have got a rota with E for Early, L for Late and N for Night.
For one particular date, e.g. in C3 there is the date, and C4 to C8 ar
the various E , L and N.
Now on the other side I want see who is actually working E, L or N at
quick glance and requires a formula to convert the E to the nam
allocated to that person and can it be done in such a way to omit th
person who is not doing the E from the column of names and avoid an
Attached is a brief example but there is about 35 staff on that.
4/7/04 5/7/04 6/7/04
John EL EL EL
Paul L O L
Charlie N N O
Jennife O L N
Charlene EL ...How do I set up a weighted formula in Excel?
Can someone help me please? I need to do a weighted formula in Excel 2007,
where the total of the numbers equals 90% of one number and 10% of another
number. Is it possible to do this?
On Mon, 10 May 2010 15:53:01 -0700, ib1qb <firstname.lastname@example.org>
>Can someone help me please? I need to do a weighted formula in Excel 2007,
>where the total of the numbers equals 90% of one number and 10% of another
>number. Is it possible to do this?
Sa g1 to j7 conta...Excel formula calculating between #'s
I am working on a bonus chart and this is what I am trying to do:
If an employee keeps his register balances between -$10.00 thr
+$10.00, they recieve 100 points. If they are out of that range the
get 0 points. I have tried playing with "IF" formulas until I am blu
in the face. Please help
Message posted from http://www.ExcelForum.com
try something like
"manickmj >" <<email@example.com> schrieb im
Newsbeitrag news:manickmj.1...Save a date as a variable and run/convert formula against the vari
What I'm needing to do is retrieve a date field from a closed workbook, save
it as a variable and then calculate a week number based on it. which I'll use
for another function.
I've attached two types of code I'm struggling with in VB and hope someone
can help... The first part retrieves a date from a close workbook and I need
to change "MsgBox" to a varible to save the date retrieved.
MsgBox TheValue("C:\GssReports", "gssreport MTTR.xlsx", "gssreport 1 ",
Function...help with formulas
I have a list of applications that have gone overdue. Here is a sample of my
Program Code Case # Delay Code
P60 721283900 AG
P60 950351513 CI
L60 217075010 CI
S60 810474413 OA
Q30 235391903 OA
S60 167004803 OA
S30 893474708 OA
S30 676254115 CI
There are several different program codes for the applications, and a few
different delay codes, leading to several differe...Translate excel formulae
Does anyone know if there exists a 'document' showing translation of excel
formulae from English to French (e.g. =counta is =NBVAL)?
(English, but living in France)
KeepItCool has a translator utility at:
> Does anyone know if there exists a 'document' showing translation of excel
> formulae from English to French (e.g. =counta is =NBVAL)?
> (English, but living in France)
Thanks Dave, although I can't open their download without deactivating th...Word wrap macro deletes formula
I created a macro to wrap text on a protected worksheet
in which each cell contains a formula importing text from
another worksheet. The cells are locked and formulas
hidden but when I run the macro, it wraps the text and
deletes the formula> how can I stop it doing this? The
macro is as follows:
' Wordwrap Macro
' Macro recorded 01/10/2004
' Keyboard Shortcut: Ctrl+w
.HorizontalAlignment = xlGeneral
.VerticalAlignment = xlCenter
.WrapText = True
.Orientation = 0
.AddIndent = False
...Help with creating a formula
I am trying to create a formula that will sum up certain criteria from one
column as it relates to criteria in the same row in another column. For
example, I want to sum up all the entries that begin with the letter "H" in
column A as it relates to an entry of "2" from column B that is in the same
row as the "H" entry from column A.
COLUMN A COLUMN B
If there is such a formula...Excel does not calculate my formulas
This is very strange...Excel does not calculate any formula. I can do a
simple =A1+A2, and it just return a zero value.
I made sure of the following:
- Cell is set to General (tried it with different cell settings too)
- Autocalc is on in settings (even a manual F9 calc doesn't work)
We might need a few more clues:
What is in A1? What is in A2?
"Martin" <Martin@discussions.microsoft.com> wrote in message
> This is very strange...Excel does not calculat...FORMULAS #35
WHERE CAN I GET A LIST OF ALL FORMULAS MICROSOFT EXCEL USES?
Excel's help for worksheet functions?
Take a look at Peter Nonely's workbook that describes lots of functions:
If Peter's site isn't working, but Ron deBruin has a copy at:
Norman Harker has his version at Debra Dalgleish's site:
> WHERE CAN I GET A LIST OF ALL FORMULAS MICROSOFT EXCEL USES?
...how to declare an array of CString?
To have a CString array, which one of the following two is a correct
declation? I was told the 2nd one is correct. Does it mean that CArray
internally uses a pointer instead of reference for its parameter lists
whenever a CString is in consideration?
CArray<CString, CString&> a;
CArray<CString, LPCSTR> a;
Thanks for your help.
Why not just use CStringArray?
"May Young" <firstname.lastname@example.org> wrote in message
> To have a CString array, which one of the following two is a correct
> declation? I was...Formula #16
I need to have a formula that can add a row of cells with a variable
number of colmns. Columns will be added and deleted everyday, so the
formula needs to have a variable range.
I hope this is clear.
...polynomial formula for a line graph...
I haven't looked at this feature in a couple of years.
Excel can give you the formula for a charted function...
what I mean is, given a few data points, it can create a
best fit curve, and display the function that it used to
Would someone remind me where, please?
Right click the data series and pick Add Trendline.
From the dialog you can choose the type of trend line and whether to
display the formula.
> I haven't looked at this feature in a couple of years.
> Excel can give you the formula for ...