|
Help with finding numbers within text and summing
I have a row of text data that has numbers within brackets, like this [20].
Cells A1:G1 have a combination of numbers and bracketed numbers. Cell J1
has the formula Sum(A1:G1), it adds only the numbers and ignores the text
cells. I want Cell K1 to Sum just the values within the brackets in the same
range.
Can anyone help with this?
Can it be done with formula or will it require VB...
|
3 |
12/13/2008 11:25:00 AM |
|
|
Cell for Changing Multiple Values in other columns
I did this years ago, but can remember how. Have several columns with
specific dollar amounts, and want to it set up so if I a cell that contains a
percentage rate for increase, and if I change this percentage all the dollar
amounts in the other columns will automatically increase by set percentage.
Thanks...
|
4 |
12/13/2008 10:25:45 AM |
|
|
create a forumla based on date
I need to create a formula based on date. I need to creat a calcualte to
include other cells only if they meet certain date requirements. The cells
will meet the requirements a certain period of time then will need to be
removed from the formula. I am trying t automate the worksheet so I don't
have to update it once a month to exclude the previous 4 weeks. How can I do
this?...
|
8 |
12/13/2008 10:20:53 AM |
|
|
Ranking sometimes shows ties and sometimes not
I calculate scores and rank the winners in a competition. The scores are a
total of points from different judges. Awards are given for the order of
finish. In the event of a tie, the awards are presented as for a tie. For
example, if two groups finish in second place with an identical score of
87.553, there should be two second place awards presented.
Sometimes the scores are identic...
|
4 |
12/13/2008 4:36:40 AM |
|
|
Find text in another worksheet when multiple criteria are met
Hello All. I am trying to pull employee's names from one worksheet
to
another but only if they are active and work in a particular
location.
Column A: Active or Inactive status
Column B: Location
Column G: EE Name
Here is what I have tried:
=Index('CPC Roster'!G2:G5,Match(1,('CPC Roster'!A2:A5="Active")*('CPC
Roster'!B2:B5="BURBANK"),0))
This sort of works except when it c...
|
2 |
12/13/2008 2:59:31 AM |
|
|
Search Formula
The following formula do not work to capture the either of the test string. I
guess I am missing something here.
IF(ISERROR(SEARCH("Direct Fundings","direct funding",AA122)),"","Direct
Fundings")
Thanks to correct it.
Dinesh...
|
5 |
12/13/2008 2:48:01 AM |
|
|
rounding the results of two times
I recently asked how to round a date and time and I got what I was looking
for but I think there may be a flaw in my formula or excel.....
A1 12/5/2008 8:00
A2 12/5/2008 15:45
using the formula
=round((A2-A1)*24*2,0)/2
gives me a result of 7.5 and it should be 8.0 so it is not rounding to he
half hour correctly ..........using the same if I change A1 to 7:00 it sho...
|
6 |
12/13/2008 1:56:01 AM |
|
|
duplicate name counts
I have a learning list for 12,000+ employees and I need to determine the
average number of courses per employee / per department. Is there a formula
we can use?
Employee Department Head Course
John Doe Steve Buck Learning 101
John Doe Steve Buck Learning 102
John Doe Steve Buck ...
|
3 |
12/13/2008 12:54:19 AM |
|
|
Sumproduct with three arrays
Hello and thank you in advance for your assistance.
I have a spreadsheet as follows:
Column C= Revenue
Column D= Units
Column E = Months, as a number (i.e. 1-12)
Column F = Status, expressed as either Prospect or Definite
Column G = Year (i.e. 2009)
Column A,B are labels and not used in the calculations.
I want to sum the units and revenue based on year, month, and status (i.e.,
...
|
3 |
12/13/2008 12:26:01 AM |
|
|
formulas in conditional formatting
i need to change the format of a cell when someone replaces the formula
(SUMIF formula)of a cell and enter the number manually, and apply this format
to a column of cells.
For example the prices in the cells are calculated using the (SUMIF) formula
to fetch the price from the price list sheet compared with the part number,
sometimes we need to modify the price for a certain part number ...
|
3 |
12/13/2008 12:25:01 AM |
|
|
Excel 2007 Pivot Table
Hi,
When I create a Pivot table in Excel 2007, when I drag more than one field
from data to “Row Labelsâ€, all Fields are stacked up in the same Column,
instead of spreading out to separate columns. This was not the case in the
previous version of Excel. Please help me to get around this problem.
Thanks,
Dinesh...
|
4 |
12/12/2008 11:46:00 PM |
|
|
I need to have a formula
Can someone please help me? I need to have a condition in which you have to
read 3 columns and then make that into 2 different parts. Here is my problem
I need to know how much to cut or what lenght to use with a standard stiles
consists of lenght: 67, 72, 80, 88, 94, and 150
A B=butt C=rabbet D=height
Paint 2 2 80
Paint 2 ...
|
2 |
12/12/2008 10:54:54 PM |
|
|
Calculate Filtered Cells Only
I have a list of value that i've built formulas to count the number of
occurrences of values that fall into curtain ranges. Now I what to filter the
data and do the calculations on the filtered values only, and not include the
other values. ...
|
8 |
12/12/2008 10:37:35 PM |
|
|
Compare 1st Half & 2nd Half of 2008.
Column A = dates...the date an employee worked
Column B = numbers....the hours an employee worked overtime
I have 70 employees / worksheets.
I've been asked to find the total hours worked for each employee for the 1st
half and 2nd half of the year.
Then determine weather more hours were worked the 1st or 2nd half of the year.
I am thinking I should use 2 IF/Then statements
If 12/31/0...
|
4 |
12/12/2008 9:47:01 PM |
|
|
Linear Regression
I have been struggling to get the LINEST function to work for me. I have
checked out the instructions for the function, and have followed them
carefully, but I can't get LINEST to return either the basic results (slope
and intercept) or the full array of output (with the STATS option set to TRUE
(or 1). I am entering the formula as an array formala, as instructed. No
matter what I do, al...
|
9 |
12/12/2008 9:40:36 PM |
|
|
Count Question - Similar Data
So with this formula and example the answer is 5; however, is there a way to
use a formula to count similiar data. For instance,
Rec 21 will have a count of 2 in the next column because it appears twice.
Rec 24 will have a count of 1 in the next column because it only appears once.
Thanks for your assistance!
Awesome! Thanks
"DaveB" wrote:
> The COUNT(...) function only ...
|
2 |
12/12/2008 9:29:23 PM |
|
|
Excell Formula copying-to-stay the same.
Hi,
I have been using a formula you helped me with before. It solved my problem
by freezing one of the locations in the formula. EG =(C6*$C$3)+(D6*$D$3)
The C3 and D3 are the price of the product.
Now my question is how do you 'freeze' this formula in place so if the price
changes, it wont change previous calculations? Basically, I have rows 1-52
indicating weeks with the above formula...
|
2 |
12/12/2008 9:26:00 PM |
|
|
Excel formula help
I have office 2007 and I need help with a formula. Specifically I have a
spreadsheet that I'm updating and I need a formula that will identify which
cells have been updated so I can track my progress. Is there any way to do
this?...
|
2 |
12/12/2008 8:43:01 PM |
|
|
Macro to Insert Current Date into cell - Macro to "Save As"
Windows XP - Office Basic 2003 - Excell 2003
1) I need a macro that will insert the current date into a cell. I do not
want the date to change when the sheet is opened or modified and saved unless
that macro button is selected.
2) I also need a macro that will bring up the "Save As" window when button
is selected. If possible to also insert a particular cell value in name field
of "S...
|
5 |
12/12/2008 8:20:02 PM |
|
|
geting a if/and number off of two list cells
I need to figure out a formula (or a set of formulas) to get a number off of
a combination of two different drop down lists.
My two lists are like this:
A - Frequent
B - Probable
C - Occasional
D - Remote
E - Improbable
and:
I - Catastrophic
II - Critical
III - Marginal
IV - Negligible
I need to combine it so that each different combination gives you a
different risk number. ...
|
3 |
12/12/2008 8:05:19 PM |
|
|
annual budget - by month help needed
I have a workbook with 13 sheets in it,
January(A4) - Beginning Balance(B4), Amount Due(C4), Amount Paid(E4)
|
|
\/
December
and a totals sheet
in the description col.(A) are monthly bills and revolving card bills. so
the bills that are monthly will not have a begining balance - on those i
would like the Begining Balance(B4) to = Ammount due(C4)
I need february begining balance to be...
|
5 |
12/12/2008 7:56:37 PM |
|
|
4 if's, with 4 different results
Not a very good subject wording, but....
I currently have 14 postitions (days off), sorted by seniority[top Sat/Sun
thru Tue/Wed]. - Current.
I only need 9 [the bottom Sat/Sun thru Tue/Wed] - Proposed
I want formulas in the Q col to indicate 4 different texts.
Being that the top group is in seniority order, I want the upper group Q
formulas to look at the lower days off, then starting at t...
|
5 |
12/12/2008 7:43:04 PM |
|
|
Sum values in a range conditional upon dates and an additional fie
Hi, there, this question is kind of a follow up to the question linked below
which is in regard to summing values in a named range based upon date. I have
effectively 3 columns of data that interest me that are named as ranges:
Item_Name, Sale_Date and Sale_Amount. I am trying to create a spreadsheet
that is broken down by quarter so I am hoping for something that is basically
=SUMIF(D...
|
8 |
12/12/2008 7:36:01 PM |
|
|
Count cells in column that contain number in a range
I have a column of times in 24 hour format. I want to have a formula that
counts the number of cells in the column that contain a time in a certain
range.
That is if the cell contains a time between 22:00 and 23:00 the cell should
be counted. I will have to do that for each hour.
I am trying to determine how many times during the night events happen in
each time period. So I want to ...
|
10 |
12/12/2008 7:35:10 PM |
|
|
sumproduct problem
I am using a sumproduct formula to summarize data from an Excel table
(regular data area) subject to two variable criteria (Excel 2003).
the relevant data from the table is a column of items numbers (named
items), a column of divisions (named divisions), and a column of data
(named amounts). Active_item and Active-div are named single cells.
This formula works fine:
=SUMPRODUCT(--(items=a...
|
7 |
12/12/2008 7:18:35 PM |