Simple Formula Excel 2003
Can anyone give me some suggestions as to resolve a problem
I want to create a formula that can be dragged down without using a
For all you Excel gurus this is rather a pathetic question but I do
not seem to be able to solve it
What I want to do in cell
c1 = sum(a1:a7)
c2 = sum(a8:a15)
c3 = sum(a16:a23)
c4 etc etc
Can anyone point me in the right direction
Well that depends...
Are you summing a repeating set of: 7 cells, 8 cells, 8 cells ?
The set size is always 8 cells ?
If the latter then use: =SUM(OFFSET($A$1,(ROW()-1)*8,0,8,1))
Portland...Im looking for an answer to a very simple QUESTION!!! Please help
Hello, im 22 looking for a used car loan and will needing my dad to cosign
for me which he has excellent credit. Is it possible for the dealer to give
me the APR he qualifies for? Or much higher because of me??? Thanks EVERYONE
Your dad would have to be the first person on the loan, you as the co-signer
.... only original borower gets the good apr
"gabe c" <email@example.com> wrote in message
> Hello, im 22 looking for a used car loan and will needing my dad to cosign
> for me which he has excellent credit. Is i...This should be simple
I have a number of cells (say A1,A3,A5,A7,A9,A11) which may or may not
contain values. If only one of the cells contains a value, I want this
value to appear in B1. How can this be done?
Spreadsheet's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=34730
View this thread: http://www.excelforum.com/showthread.php?threadid=557388
If they are all all numbers:
=IF(COUNTA(A1,A3,A5,A7,A9,A11)<>1,"not exactly one!",SUM(A1,A3,A5,A7,A9,A11))
(summing empty cells wo...Conditional Formatting macro: simple, but doesn't work
Conditional Formatting macro: simple, but doesn't work. Using Excel 2007
with Windows 7.
Enter the number 1 in cell A1 and the number 2 in cell B1.
Start the macro recorder.
Click Conditional Formatting, New Rule, Use a formula.
Enter: =$a1<>$a2, Format, Border, select a continuous bottom border, OK, OK.
Select cell B1 (only).
Click Conditional Formatting, New Rule, Use a formula.
Enter: =B1<>C1, Format, Font, Color, select red, OK, OK.
Stop the macro recorder.
Everything looks perfect with a line under cells A1:B1 and red font in cell
B1 (o...Another simple formula??
Very simply I want to take the unit price (a1) * Qty (b1) and add the sales
tax (c1) and have the result in one cell (d1). I can do it with helper
column but would rather not. The answer should be $5.89. (d1)
Your D1 figure is wrong. It should be in the $5.81 or $5.82 range based on
how you rounded the result.
Choose from the following formulas, and place one in Cell D1, drag and fill
down the rest of the column:
Will give you $5.81
...HowTo: Reduce "memory footprint" of simple app?
I'm developing a relatively simple MFC SDI app that has an objective
of working well on "dinosaur" computers (old Pentium or 486, minimal
memory, Win95, VGA resolution).
MFC apps seem to have a default minimum memory allocation of about 4
megs, regardless of whether the app does much of anything. With
Win2000 and and WinXP, the TaskMgr indicates that a wizard generated
SDI app is allocated about 3.7 to 4.0 megs.
My impression is that it is possible to set an option for the linker,
or make a call to the o/s to relinquish quite a bit of this memory.
However, I haven't found t...simple xml for states list
How to create a simple XML with US States list and read it into a
I am very new to Dot Net technology as well as xml.
I am building a desktop app in C# and need to populate the US States
list (AL, AR, .. WY) in a combo box. I could have done it by reading
from a table in SQL server but rather prefer to have that list saved
locally at client side as an xml and read it from there. what is the
simplest way to go about it, what should be the structure of xml
document and do i need schema also ?
thanks for any response
My answer for (almost) everyth...simple query changing set of numbers from positive to negative
have a string of numbers in a column that are positive and would like to
and would like to make place minus in front
Put -1 in an empty cell, copy it, select the numbers and do edit>paste
special and select multiply
"sammy" <firstname.lastname@example.org> wrote in message
> have a string of numbers in a column that are positive and would like to
> make negative
> 1...convert dual core to quad core is simple
do you people know there is a very easy way to convert your dual core into a
quad and its inexspensive
what are you smoking, kid?
> do you people know there is a very easy way to convert your dual core into
> quad and its inexspensive
You have not heard of the old "Duct tape one CPU on top of the other trick".
PA Bear [MS MVP] wrote:
> what are you smoking, kid?
> jaguarxj6 wrote:
>> do you people know there is a very easy way to convert your dual core
>> into a
>> quad and its inexspensive
>...Simple problem from a simple man
Hi,I have a table which records several different scores for eachrecord / entry. Is there a way that the report based on the query , inturn based on the table, will show the scores below a certain level ina different coloured font?Cheers,TC...probably very simple
I'm trying to set up a simple spreadsheet of medical expenses. I'd like to
be able to type a doctors name into one cell and automatically have excel
enter the mileage into another cell. I know I'd have to put the information
in somewhere, but I just don't know where to start. Combined, our family of
5 has about 6 doctors/specialists that we see on a regular basis, so this
shouldn't be too difficult (I hope).
Thanks in advance for any help.
to give you a starting point:
1. Setup a table with the doctor names and the mileages. Lets call this
sheet 'data'. It...Help with a simple print macro
I have inherited a spreadsheet with a macro built in. The macro is in
a sheet and simply prints the next worksheet in the book. However,
I've changed just one thing in the sheet to be printed, I've protected
it. Now I get the message 'you cannot use this message on a protected
sheet' When i depress the debug button it highlights 'Set rng =
WS.Range("A1").CurrentRegion '<<< Change' as being the problem.
Can this be resolved ?
One way would be to modify your macro to first "unprotect" the sheet, then do
your prin...Running a simple batch file at startup
The CMOS battery is gone bad in my Windows XP machine.
Whenever Windows starts, I want to run the 'Date' command to set the
current date. How do I accomplish this?
Thanks in advance.
On Thu, 19 Nov 2009 06:41:38 +0530, samah <email@example.com> wrote:
> The CMOS battery is gone bad in my Windows XP machine.
> Whenever Windows starts, I want to run the 'Date' command to set the
> current date. How do I accomplish this?
Why don't you simply want to replace the battery? It's easy to do and
extremely inexpensive (two or t...Q: simple Access to Word mail merge
I'm using Access 2003 to mail merge to a Word 2003 doc.
Below is the code that I modified from the microsoft website.
Dim strWordDocName As String
Dim objWord As Word.Document
Dim strTableName As String
strTableName = "MAILMERGESUBSET"
strWordDocName = "S:\PATH\MailMerge.doc"
Set objWord = GetObject(strWordDocName, "Word.Document")
objWord.Application.Visible = True
Connection:="QUERY MAILMERGESUBSET", _
ReadOnly:=Tr...Simple encryption solution
I'm looking for suggestions for encrypting/decrypting strings.
In the app, there is a (potentially huge) unicode string which is an
entire xml file, ready to be written to disk. I'd like to encrypt it
with a user-supplied password, write it to a file, and later read the
file and decrypt it (in memory). Post decryption, it will be run
through an xml parser.
All the encryption solutions I've run into seem overly complicated for
such a basic task.
On May 15, 12:03=A0am, ab` <a...@absent.com> wrote:
> I'm looking for suggestions for enc...Am confused about a simple data layout- need help asap!
This is really silly, because I am good at charts, but for some reason, I
cannot formulate in my head the proper layout of this chart. Here is what I
THESE ARE MY DATA HEADERS:
A B C D E
PERSON JOB 1 JOB 2 JOB 3 TOTAL ARBITRARY
THE DATA LOOKS LIKE THIS:
A B C D E F
NAME1 3 2 8 ...Simple Delete Query
I have a table that includes the field titled "State". I want to delete all
records in a table except records that have "AZ", "CT" or "NY" in the state
field. I have tried the criteria of =Not "AZ" or"CT or "NY", but I'm not
getting the correct results. I only retain AZ records. Any help you can
provide is appreciated, thank you.
"SITCFanTN" <SITCFanTN@discussions.microsoft.com> wrote in message
>I have a table that includes the fiel...Simple loop question
Hello, I have a control that has a number in it (e.g. 5) I need to repeat a
task for the of time in my control. I guess it should be something like
Dim MyCounter as long
MyCounter = me.counter
Do while myCounter = 0
mycounter = mycounter -1
Change the "Do while myCounter = 0" line to:
Do while myCounter > 0
Doctor Access Downloads Page:
> Hello, I have a control that has a...Simple chart
On my excel worksheet, I have two columns. In column A1 I have the title
"YEAR" followed by various years like 1994, 1995, etc, and in B1 I have the
title "AVERAGE", followed by values for each year. I highlight A1:B12 and do
the chart wizzard and get a bar chart which spreads the value of both year
and averages. The X axis is just a consecutive number and the y axis spreads
the values of years and averages. What I want is a chart where the X axis to
displays the years from the A column and the Y axis to displays the numbers
from the B column. How do I do this? Tha...Need help with a simple query
Hello, I need help with this problem. I have two lists of dates. I am
using a table as a filter for this list. What I want to do is create a
final listing of all dates that are less than the minimum date in the
filter. This is probably easier to demonstrate than to explain:
Essentially, I want to display the MAX value from Data that's year is
less than the minimum value of Filter(Table). The result should be
Max(data_field) AS max_date
Ye...Simple(?) Outlook / Exchange question
I'm using Outlook 2003 with Exchange 2003 for my e-mail. I have
however a number of e-mail addresses, such as firstname.lastname@example.org,
When composing a new email in Outlook (and sending it via the Exchange
Account), how can I specify which address the From field should be set
I know I can create additional accounts, but these require SMTP
addresses for the outgoing servers.
Set the address in the From field
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the mo...Ordering results, not as simple as it sounds
Hey Everyone, first my disclaimer...not my design, inherited, so please don't
complain about table structure, I already know. Thanks...onward.
There are 2 tables
First table holds time-keeping data (just the important stuff listed)
Job Number (Number, Long Int.)
Operation (Text, 50)
Second Table shows the "Process Control" on a job...this is the ugly one
Job Number (Number, Long Int.)
I can get the query that shows the Job# and Operation from table 1, but I
need all the gathered information to be in order a...Can't solve simple? problem. Can some genius out there help!
Want to pull simple data from two tables/sheets into a third and use formulas
(array or otherwise), not macros or filters. I only want to select rows for
customer CARL. Below is the example:
Table Deposits (First Table, one data source)
Customer Date Deposit
Carl 1/25/2008 $150,000.00
Carl 2/28/2009 $50,000.00
Table Withdrawls (2nd Table another data source)
Customer Date Withdrawl
Carl 1/28/2008 (6000)
Joe 3/1/2008 (3000)
Carl 4/12/2008 (4000)
Joe 5/5/2008 (7000)
The desired final result is listed below. The column with the name CARL can
be omitt...simple excel question
I think this should be a simple question but for the life of me can't
determine the best way to do it.
I want to have a spreadsheet where the daily totals are entered to keep a
running month to date and year to date total. I don't care about
maintaining the daily input numbers.
Today's data MTD YTD
10 10 10
Now for tomorrow
20 30 30
And where is a date entered to determine which date is to be considered for
dona...Simple hack to get $500 to your home.
Simple hack to get $500 to your home at http://uknews.tk
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque.please dont tell to anyone.