Formula Help #37
I am looking for a formula that I can put in a cell to add up all the water
in A1 to A5 that has clean next to it in B1 to B5. Could someone please tell
me how to do this.
a b c d e
1 Water Clean
2 Water Clean
3 Soap Dish
4 Soap Laundry
5 Water Spray
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Jeremy" <Jeremy@discussions.micr...excel corresponding a formula with a date
I have multiple formulas running down my page in column b to rip certain
things from my sales reports that i have saved in my documents. When i save
these sales reports they get saved with a certain date of the week ending.I
need a formula that will be able to correspond with the dates going down the
page in column a, as i dont want to go down through hundreds of formulas to
manually change the date. there must be a certain formula that can be
included in my formula to rip this certain information.
HD:Users:Liane:Documents:[DeeWhySalesreport061209.xls...lost two months of received emails
Help I lost about 2 months of received emails. They are
not in my deleted folder. I already tried the pst restore
...Convert years:months to months
Hello- I am hoping to use Excel to convert data that inputted in a
years:months format to just months. For example, I want to translate
5:3 to 63 months. I'm running into one hiccup: Excel views the
inputted data as time and is translating it into 5:30 AM, making
calculations challenging Does anyone have any tips?
you may need to format the cell a General as Excel can be overhelpful and
use a time format
Microsoft Excel MVP
"Jen" <firstname.lastname@example.org> wrote in ...Formula is changed to a constant
I changed a reference in a formula from relative to absolute using the F4 key. Now Excel thinks that cell is a constant and prints the forumula, including the equals sign, but does NOT compute the formula. This is infuriating!
not quite sure how you did this. F2 followed by F9 would convert a formula
to a value.
Perhaps you pressed F2 and then F9 instead of F4 ?
Just a thought; can't reproduce it any other way.
"Terry Moore" <email@example.com> wrote in message
> ...Matching invoice not available on receiving that have been return
If I return without a credit in POP (because I never match the receiving
with an invoice), the link should be made to assure that it is impossible to
still match the receiving that includes the items that have been return with
an invoice. I tested it and GP allow it.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and...This Month and Last Month
In the same query, I am trying to get two counts so I can compare them
in a pivot table.
I want a count of ServicesID for the current date this month AND a
count of ServicesID for the same date last month in the same query.
Use a subquery to get the count of services for the same date last month.
Here's an example of how to do that sort of thing with a subquery:
That example does year-to-date calcuations, but the process is the same. In
your case you will be counting the ServicesID field where ...formula.
I'm in need for a formula, if in cell A for example i introduce numbe
2 and in cell B number 3, cell C would give me a total of 5. But if fo
example i write '23' in the same cell (a) i want cell b to give me
total of 5, so even if a write 53 it has to count it separately 5+3=8
can you please help me with this formula, as i'm badly stuck with it.
Motilulla's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3715
View this thre...Need formula help
I'm using Excel 2002 with SP3 and am having difficulty with the formula in
All of the steps of the formula need to reside in cell D14 so the result is
May go through up to 20 steps to arrive at result, depending upon current
date, which is present in cell C3 as =TODAY().
Cells O4 through O23 have dates 1/21/2006 through 8/21/2007. Contents of
these cells are formatted to be raw five digit number.
Cells P4 through P23 have differing dollar amounts, from $12,727.27 down to
=IF(AND(C3>=O4),(C3<O5),-P4,Go to next step)
=IF(AND(C3>=O5)...How to change a formula reference?
I need to create a formula that references a range of cells. The range is
supposed to be determined by what the user enters into another cell. Can a
formula have a variable in it that will grab a number from another cell?
Where you see B18 the user has entered in a number, we will say it was 5. I
need the function to reference the cells in the N column from N5 (cell B18
has a 5 in it) to N10 (B18+B18 or 5+5).
I appreciate any help you all can give me. Thanks so much in advance.
Assume you enter in cells:
A1 = 5...can you hide rows with a formula?
on my last sheet there should be an overview of the data selected by the
user. If the user doesn’t select all the blocks with data “because he thus
not need that particular block”. There will be empty rows between the
information on the last sheet!
I need all the info under each other, so that the user will have a short
clear overview that will fit on 1 page to print. (this should be all
Is this possible by hiding the empty rows with a formula? Or is there
(The sow called “empty rows” do contain formulas that hide the data blocks
that the user thus not need)...IF Formulas with Ranges
I'm trying to create an IF formula where the workbook will recognize if
there is data added to a column D range (Sessions) and then apply a
formula to the last cell of column F range (Aimline).
Hence, if Sessions (column D) which now has the numbers 1-27 in it gets
28 entered below, then the cell in the same row but column F will take
the number 28 and apply the formula above it =$F$8+($A$12*D35).
Can anyone help?
made an assumption that D35 should relate to D28
(remove nothere from email address...Conditional formatting / formulas
I set up a table with a list of states in one column and amount of
tons in another column (ex from the book). I set up a conditional
format in a cell above the table to highlight all similar states when
entered in the above cell; ex: when I type IOWA, all IOWA listings
will be highlighted in the list. Then I tried a formula next to that
one that will add all the tons for each of the highlighted states. I
looked on the Internet and found a formula using MATCH but it only
entered the amount from the first IOWA, not the rest.
Does anyone have any idea how I would write that formula. Would I use
I'VE ACHANGEABLE NUMBER IIN a1 AND I PUT IN b1 "=MONTH(A1)
IN ORDER TO GIVE ME THE MONTH'S NAME WHEN I CHANGE THE NUMBER IN
A1 BUT IT DDINT WORK
THANXXXXXXXXXXXXXXXX FOR AL
frsm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3123
View this thread: http://www.excelforum.com/showthread.php?threadid=51453
I believe you have to have a date in A1, not just a number.
"frsm" <firstname.lastname@example.org...Month By Month report
Does anybody have an RMS HQ sales report which would show sales in � by
Ideally each month across the top of the page, and each
department/catagory/supplier down the left of the page, with the value of
sales each month.
I would run this for the period of a year and it would show all my catagory
sales per month etc.
I am sending you the reports, once get then rate it.
"Philip Gass" wrote:
> Does anybody have an RMS HQ sales report which would show sales in £ by
> Ideally each month across the top of the page, and each
>...Getting the "name=" (bit, picklist) value that is returned from SOAP
OnChange event to poulate other field on a case.
One of those fields is a bit, and one is a picklist. Those nodes in the
response come back with <attribute="new_active" name="true">1</attribute>
for the bit field and <attribute="status" name="On Hold">3</attribute>
How can I read the name value? I've tried selectSingleNode("//status").name
with no luck.
I am doing a similar process, using a SOAP response message. I ge...Is there a way of Making monthly tabs without typing each month?
I would like to avoid typing in each month every time I create a workbook.
I have to do individual yearly workbooks. Is there a faster way to make
monthly tabs. Example type Jan, Feb, Mar and then somehow the spreadsheet
would fill in the following monthly tabs?
The easiest way is to make a blank file with appropriate tab names, and
then make copies of that file.
Or, create a tab called "List", start your list in cell A1, and run
Dim Nayme As String
Dim K As Byte
K = 1
Range("a1").Select 'this is the first cell in List
Do Unt...Is there a formula?
I want a formula to count the number of time a word appears in a column. so:
f1 orders 3
g1 closed 1
Is this possible and how?
Your references show the data in one row. Assuming the data is in
column A, then try this to count the number of times "order" appears:
Hope this helps.
And if you want to get the total for ALL words, try a pivot table
...How would you do this formula?
how would I do a formula if the rules for the contest that Im working on read
like this...If you sell $800 you get 2 points and each additional $100 you
sell you get an additional $100 to a max of 10.
Message posted via OfficeKB.com
where the sales are in cell A1.
For the increase above 800, the increased is rounded off to the nearest 100.
Trisha V via OfficeKB.com wrote:
> how would I do a formula if the rules for the contest that Im working on ...counting occurences specific month appears
You've helped out before and I come to you again. Here's the question...
5 worksheets in my workbook, each representing a different office.
Column A for each worksheet is the date in the following format: 03-May-10.
Let's say the first sheet is named Montreal Office, the search range is
A3:A5000, what formula am I supposed to use? I think from past posts, I'm
supposed to use =sumproduct but I don't know how to incorporate my specific
Thanks so much,
On May 4, 5:41=A0am, MM <M...@discussions.microsoft.com> wrote:
> After...Help with formula: finding text
I would like to ask for help with a formula for comparing name in a cell
with a list of names in a table. If there is a match it should return a
associated text to the matched name from the table. If no match it should
just leave the cell blank. Thanks in advance
Please click "yes" if this post helped you!
"Jonas Ornborg" wrote:
> I would like to ask for help with a formula for comparing name in a cell
> with a list of names in a table. If there is a match...First day of Next Month
In A1 I have the date 3/10/10.
In B1 I would like to insert a formula that will show the Date 4/1/10.
Basically, I would like a formula that will show the first of the next month
no matter what date is shown in A1.
Thanks for the help.
Please keep all correspondence within the Group, so all may benefit!
"Jim" <Jim@discussions.microsoft.com> wrote in message
news:3A3346E7-C4DE-...Cell to show the last 2nd Month
I'd like to show a cell where it shows the last 2nd month
of another cell, ie, in Cell A, the date is 03 May 2004
and I'd like Cell B to show March. I know the format will
be MMMM but how to I get it to show March instead of May.
How do I do it?
With formula cell formatted as you said, "mmmm".
Please keep all correspondence within the Group, so all may benefit!
"dolphinv4" <anonymous@discussions....Earn $700/month Guaranteed Payment #2
Start earning within 15 minutes Join as Supervisor.
Step by step instructions and Full Tutorial
$700/month Guaranteed Income!
I need to know if there is a way to create a formula that will allow me to
enter multiple values in a cell at different times and this formula will sum
I would enter 10 in cell B3.
An hour later I might enter 25 also in cell B3.
After the second entry I would want it to automaticaly display 35.
Is this possible and how would it be done?
Thanks for your help.
At the bottom there is a formula solution turning on iterations
"Brad Grow" <Brad Grow@discussions.microsoft....