Example: I have data in column A1 through A95 and I only want to sum every
other cell how do I do that without getting an error message.  The sum cell
would be A97.
Al

I'm trying to LOOKUP value #1 in one cell, then LOOKUP value #2 in
second cell.  Based on the result of those 2 LOOKUP's, I want th
furmola to return the correct value from the intersection of th
LOOKUP results in a table of data.  I'm stumped...is this possible?

I have a cell with 5 digits stored as text.  I need to add 3 zeros to the
cell so my total digits in the cell = 7.  How can I add the zeros to the
beginning of the cell?
ie. current digits = 4204, desired outcome = 0004204.  The cell must remain

I am creating a database and want to lookup data that is added to a worksheet
template.
Once I create the template for the worksheet, I want to be able to expand
the table and still have the correct info in the worksheet cell.

I wish to validate that certain cells have been populated with data and
prevent the "save" function if these cells are "blank".
Can anyone help?
Thank you,

Hello!!
I´m trying to find a formula that changes the number in one cell, in a
consecutive way, using a macro button or every time the file is opened.
Example: The way a number of an invoice changes and doesn´t repeat itself

In column A I have numerical data, e.g. 50000. In column B I have a drop-down
box so the user may select either X,Y or Z. The user may also leave column B
blank. The user will input a number into column C.
In column C I am trying to set up Data Validation, as a decimal with min ...

In Excel - how do I format a reference cell so that the reference changes as
the source cell changes.  example:  Source cell on one worksheet; reference
cell on a linked worksheet.  If I resort the worksheet and the source cell
moves, the reference is not moving with it.  The ...

I have a worksheet filled with cells that contain formulas with $ signs i.e.
reference to particular cells.
Is it possible to select all cells and remove the absolute reference at one
shot, instead of manually fixing each formula in each cell? Tks a lot! -

Hello Group
I need formula help....
I need to find the Max value of A1:Z1 and then match it with the value in
the row where "CAT" resides in Col A in the range A2:Z23.  The target

If you hit the End key the word END appears in the status bar and there are
shortcut keys to use when in "END mode".  But I can not find an explanation
of what END mode is or what it does.  It is not in the help file.

How do you set up a page template so that when I go to print a worksheet, I
don't have to reset the orientation as landscape, reset margins, and the
like? I have a workbook, and everytime I add a worksheet, I now copy another
worksheet and paste it on the new worksheet, but all ...

I am using the formula "=Workday" but I want this formula to include
Saturdays.  I have a Start Date and a duration and want to calculate the end
date with Saturday included as a work day.  Can anyone tell me how to do
this?  Any assistance would be greatly appreciated.  Thank ...

How Do I create a Macro that will allow me to jump to the next Cell Row 1 no
matter where my current position is?

I need to figure something out on my sheet.  The “mode” function tells
you witch value repeats the most.  I want to see if there  is another
value that repeats just as much.  Also, I want to see what value
repeats the second most.