i know formula but can't get it to work;
I have to take the sales for the day multiply it by the accounting day and
then divide it by total number of days but it keeps giving me an error....new
at this please help

I have entries in 3 different columns.
A1 = PN
B1 = 62456
C1 = D

I have a speadsheet that has 7 worksheets, each one is a month of my credit
card statements, is it possible to make a 8th worksheet and have it search
the other 7 and find any cells that contains the word "wal-mart" in them and
have them all appear in the 8th worksheet. In other ...

I have a list of dates in one column. In one cell, i need to know the
range.
I tried getting the min value in one cell , then the max in another,
then i combined the two using CONCATENATE however, that only returns

I'm looking for a formula that will do the following:
A1-A12 contains numbers. and I want a formula that will add up whatever
number of cell I enter in B1
example: B1, I enter 6

When a new calculated field 'calcfield' is created, a 'SIGMA values' is
added to the column-labels-area, and a 'sum of 'calcfield' is added to
the values-area.
But I want to use the new field in the row-labels-area, and it is

I'm trying to set up an executive summary worksheet or report that would be
automatically (or semi-automatically) updated as the underlying data
changes. A simple example to illustrate my scenario:
Assume an "Employees" worksheet:

hello all...
first... thanks to all who offer their expertise..... this group has been  a
wonderful asset.
My problem.... a few weeks ago I built a spreadsheet whereby I could enter

I have a sheet with lots of blank rows.
Is there any way to compact things, and remove the blank rows all in one
shot ?
Thanks,

I am a novice when it comes to macros...but I have to copy a bunch of
spreadsheets...both copying to the same workbook and copying to a new
workbook...I'd like to streamline the process and rather than copy/move,
etc., I wanted to either make a macro button or a shortcut key.  I ...

The sort box gives three, can there be 4 (through an Add-In or
something)?  Thank you for your consideration.
John

Hello there! I have three lists. The first one is artists. Artists
contains names.The other two are 2 different name of artists that
contain Albums. For example
Artists           Korn                   Deftones

I hope that somebody can help me with the following issue with Excel
Charts.
The x-axis is the timeaxis with labels every twelve months. However,
the displayed data may extend beyond the last label. That looks very

Thanks to many helpful directions from this group I am using the formula
=IF(D9>C9,MAX(0,MIN(D9,"15:00")-MAX(C9,"7:00")),MAX(0,"15:00"-MAX(C9,"7:00"))+MAX(0,MIN(D9,"15:00")-"7:00"))
to capture the hours during a person's regular shift (7:00-15:00) that
may have been worked on a ...

I am wondering if this is possible:
I have a word document that contains a TOC (table of contents).  Is it
possible to automatically import the TOC into excel?
I have tried embeding the document but it imports the entire document, i