I have a situation that requires the need for weight averaged subtotals and
totals. I have no options but to use Pivot Tables for what I am trying to
accomplish. I record coal train data for 25 different contracts and need the
ability to show weight averaged coal qualities in my ...

I like the conditional sum wizard with one exception. I can't edit the
resulting formula without invalidating it. The wizard adds a { to the front
of the formula and a } at the end of the formula. When I attempt to edit the
formula the { and the } disappear and the formula no ...

I had never expected the result that comes out from this example:
Excel cannot mix text and figures in 1 single list of values. Her
comes what happens:
My model contains, in A1 to A6 the values

Start Time = 09:30
End Time = 16:00
Senario A
A3 = 01-JAN 08:28

I am trying to create a work schedule that will graph all employees for an
entire week.  I'm not sure how to set up the date portion of the spreadsheet
to get the graph.
In column A I place the employee names.

Can anyone help me? I need a function that provides the following:
If a1*a2=a3, then show Good,  else show Try again. This function is written
in c3, and I can make it work. But if a3 is a blanc, i want to show c3 as a
blank without ruining the function in c3. Is this possible? My ...

I am trying to produce drop down boxes in Excel That will produce a sub menu
from main menu.
       Glass.
       Plastic.

Formula =SUM(E10:E20)
If there are no amounts in this column then the total displays 0
Is there a way to display the total cell as blank so that the 0 does not
appear.

I have an excel sheet (template) where I enter numbers.  Sometimes the
same numbers are entered twice, which is a good thing since it can
pick up mistakes if they are compared by the computer.  For example:
12345

In my excel worksheet having more than 3 pages(like sheet1,sheet2...)
i editing in page 3 and saving, next time opening that workbook opening page
3 with same editing line
i want when i open that file default view page 1

I wonder if someone can help me with this...it's driving me crazy.
I need to delete a leading space from multiple cells, 200 or more. The
leading space is in front of text that is often more than one word so I can't
just copy into Word and do a find and replace on the spaces.

I am trying to develop a decision matrix and I can’t figure out how to do it
even tho it seems to be staring me in the face.
I have information from several different sources that provide subjective
numeric criteria in various categories about the same item, but the format

I am looking for a template for myself, to show where I am going to be at
certain times ie at school at scouts at work or at guides.
Can anyone help?

This may be simple but I can't figure it out. I want to see a number each
time I open a particular spreadsheet that is calculated based on the number
of days that have passed from the first day of the month. I don't want to
have to enter todays date, that should be automatic. ...

If possible, I would like to use SUMPRODUCT to achieve the following:
Two ranges - H$5:H$41 and I$5:I$41. Both ranges have some blank and empty
text cells included. Using the flexibility of an input cell to reference the
various Text Labels I would like to count the times a specific ...