I have dates in column A
Numbers in column B
I want to find the sum of numbers on column B that correspond to the last 30
days (including today), 90 days, 6 months, 1 year.

I have a file that was sent to me with a column of dates that appear like
20070602.  I need it to look like 06/02/2007.  I have tried to format it but
I get ########### and the screen says something about a negative number.  If
I open a new blank worksheet and type it in 20070602 ...

I have a 20,000+ row table with twelve columns of monthly precipitation data.
Each column is a month of the year and each row is a yearly record. Missing
data is denoted by -9999. As you can see from a sample of the data below,
yearly records (rows) vary from being complete to ...

I would like to filter in a column using 3 choices:  ends with 1, 2 or 3.  I
cannot figure out how to add the third number

I'm tyring to use a VLOOKUP formula that will look at a name typed in a cell,
then have it look up that name in a named range and total the amounts
attached to that name.  The use is for costing hours spent on a project from
time cards.  I'm going nuts trying to figure it out.  I ...

my sir had given me an assignment.please help me with this question

1) Is it a true statement that Iteration is only relevant to allowing or
disallowing Excel to try and calculate a solution to circular reference
errors? (I have a co-worker who seems to think that if a workbook contains
VBA code where there is a loop, you need to turn Iteration ...

A simple calculation formula result is not displayed correctly.
Formula: "=3+3"
Expected result: 6
Displayed result: 0

I need to know if one can enable macros and automatic calculations on the
Excel Viewer software.  Will appreciate any help I can get.

I get databases from two different sources.  The larger one has six columns
of information including an email address.
The smaller one has the same email addresses amongst its columns, though far
fewer rows.

When creating a financial proforma I calculate monthly revenues that need to
be rounded to nearest $100.  How can I combine the formula and [round]
function in the same cell.

I am trying to find out how should I proceed with the folowing problem.
I have a group category of data in sheet 1 as folows:
Sheet1
COLUMN A:A

Gidday
I am seeking a bit of help with what the "-{1,7}" does/means in the
following formula;
=ABS(IF((DATE(YEAR(C3),MONTH(C3)+1,DAY(C3))),(C3)-(DATE(YEAR(C3),MONTH(C3)+1,DAY(C3)))-SUM(INT((WEEKDAY((DATE(YEAR(C3),MONTH(C3)+1,DAY(C3)))-{1,7})+(C3)-(DATE(YEAR(C3),MONTH(C3)+1 ...

I have a 600 page spreadsheet, I only need to print certain rows with
comments.  How can I avoid printing the entire worksheet.

Hi there, I have one sheet ('A') with a range of dates (dd/mm/yyyy) in row 3.
In column A there are some times and the cells from column B onwards, will
have values in pertaining to the times on different dates.
I want to create a second sheet lists the same times and when the ...