Hello; I’m trying to sum cells A1:A10 across several sheets no problem.
However, if cell B1 on each of the sheets does not equal the value of 1
found on the Summary sheet, then those sheets would not be added.
In other words if Sheet3 cell B1 has a value of 2, then Sheet3 would

I was hoping someone could shed some light on this.I want column B to
identify the day in column A and express it as text.
I.E. when column A is 01/10/07,coumn B displays  ' Mon'
column A             column B

On my worksheet Column A contains dates 1/1/08 thru 12/31/08 (A2:A367)
Column B contains entries for dates in Column A. When I select a certain
date I want to be able to count the cells in Column B that contains a number
up to and including the date selected. Can anyone help?

I have a database that has a date format of yyymmdd. I need this to be
mmddyyyy. How can I change this?

i have transaction date in column A balance in column B
i need  to calculate interest on minimum balance in a month and calculate
year interest
exmple:

Hello,  
I have a formula that separates the first and last name in a cell.  It works
for the last name  but does not work for the first name,  I either get a
partial first name or I get the first & part of the last. A nice person by

How to use rank and ABS functions to rank the set of + and - numbers to be
ranked from 0 and up regardless +ve or -ve number:
A                 B           C
Data    Take

How do I get the top row of cells to slope 45 degrees?

First off I am using Excel 2003
I have a workbook set up to cover my financial assets. My first worksheet
(Sheet1) is the main one which has all my data on it. The other worksheets
are where I have the detailed information to get certain figures - for

I have a pricing spreadsheet with formulas that calculate my retail pricing.
The pricing column has numbers for example $547, $342, $146 etc. I would like
them all to end with an 8. $548, $348, $148 etc etc.
Does anyone have any suggestion on a formula to make all my retail ...

I have a list of questions, which I want to be selected on another sheet at
random, the range is Sheet1!A1:A10 and when I run a command, I wish to have
one of the questions from the selected range chosen at random.
ie. [very simplistic example]

I have a workbook which contains 12 sheets.  I want to create a table of
contents in excel that hyperlinks to each page when I select it.  The first
sheet is the cover which doesn't need to be hyperlinked.
Also, I need this table of contents to still work if I PDF the file.

I have to sum the numbers in column B *column C in column D.
The problem is that the data in column B are not always a numbers and some
times are zeros.
What is the formula that will take into consideration only the cells with

I know a few of you have helped me in the past and the sugestions have been
great but I'm still having trouble.
What I need to do is calculate a week of time including sick and vacation
where each day has it's own cell. ie S M T W R F S, and if anyone works over

When I use the formula below I do not get the correct answer for the first name
The name on one is Joana Zeltzer  When I
use the formula below I get the last  oka but the first name comes out as
Joana Z.  On the next which is Paula Gonsalves i get last name ok but the