I need some help with a worksheet problem!
I am trying to calculate how many serving sizes there are according to
what size is chosen from a cell & the amounts are from another
worksheet.

I have a "master" spreadsheet which consolidates information from multiple
sheets in the workbook. I need to insert a line in all the sheets, including
the master, and have all the other rows retain their formulas in all the
sheets. How can I do that?

Dear Sir,
I have an opportunity to use MS Excel 2003 extensively at my work place
recently.
Previously I was using Corel Quattro Pro Spreadsheet.

This SUMIF function isn't working.  Is it the non-continuous range it doesn't
like?
=SUMIF(R38,S38:T38,V38:Y38,AA38:AC38,AQ38,AZ38,BD38),"<>0")

I have a schedule that has dates in it.  As the dates pass, I want to fill in
the cell so that you know to go to the next step.  How do I do that?

I have an excel workbook that contains 3 cells that need to changed each time
you open the file for it run correctly.  How do I create a message or prompt
that appears each time you open the file that says what to do?

I am trying to create a formula so that I will enter a date in one cell (ex.
Oct 11, 2006), I would then like another cell to take this date and add 3
workdays and therefore be October 16, 2006 (so it doesnt count the weekends).
I am not sure if this is possible, but any help ...

If only a certain number of cells in a column are highlighted, can the
highlighted cells be counted?

I am recording degrees in a land survey and wish to use excel to quickly
calculate the angles for me.
I am stuck as to how to imput an angle, not in decimal format, but in
degrees, minutes and seconds so I can then subtract one from the other.

I have and equation that is in cell r26 as follows: =sum(h26-t26)
this goes into cell r26 and is displayed either black or red, depending on
if positive or a negative number.
I have tried to put an equal sign in cell v26, then hit the cells: r26 and

What IF formula question.  My cell has a formula in it  =sum(H43/G43).  I
want this cell blank “” If the result is not a percentage (the cell has been
formatted to be a %).  When I drag the formula to many other cells some of
them are #DIV/O! and I want those cells to be blank.

all worksheet entries are either labels or_______________?

I have tried using SUMIF but am stuck in 'criteria'. I have two columns with
week date and amount for each employee. I want to total and show the totals
for each month.

No matter what I try, I cannot get Conditional Formatting to work in the
cells of a workbook (all spreadsheets).  Any ideas?

Excel 2002 SP3
When I open a worksheet, I get a pop-up that says that the worksheet
contains macros. I never created macros in that worksheet. "Tools", "Macros"
doesn't list any.