I need a formula to calculate the following;
Year 0 invest -$ 2,252,483
Year 1 invest -$   129,937
Year 2 return  $407,451

Sorry but I have done this hundreds of times and have suddenly gone blank on
the formula I use:
I have a Totals column and a Today column - I want to change the amounts in
the Today column daily and that will then update the Total column. I'm sure

I have a data table ( originally pulled from another spreadsheet using SQL
query - probably irrelevant to the issue  ).
When I try to SubTotal with the sum function it incorrectly returns zero for
all results. The cell formats are number. Any idea what's going on here ?

I have a string range1 insted of A1:C1, for instance.
My search cannot be completed because the formula is somehow unable to
search for the string, it searchs for the the text "range1", which is really
odd.

It's been years since I've really dug into a spreadsheet with lots of
formulas.  I've forgotten how much fun it is.  I used to be a Lotus 1-2-3
Release 1A wizard.  That's how long it's been since I've built spreadsheets
with even a medium complexity.

Please Help, I've done every thing the online help provided. Like below in
the Custom block
\A 000 \A\A 0000
E 000 "EE" 0000

I have the following formula used to compare a list of vendors to entered
data and the make the calculation.
=SUMIF(A2:A98,I2,F2:F98)/J2
I want the cell to display either blank or 0. Is there a quick way to

If you have the $ sign on a reference   Sheet1!$A$1   where you paste
a link into another sheet, why does it sometimes not show the data
from the link and you need to press enter over the cell again for it
to work????

I have divided 36 numbers (1-9) into groups of 4.  I need to randomly pick 1
number from each group.  How do I do that?

I tried to save a excel worksheet and it moved to an Incompatible page and I
can't get back to my dataa sheet.  How so I get back?

I am having a problem where the cell value is changing every month, bu
I want to know the January value of a cell, in any month.
file is attached
Thanks

Hi again,
I have sheets called back1 thru to back35. In all the sheets Cell I2
and Cell J2 must have a start time and end time  entered before a user
exits the sheet ie:  0700    1526.

When multiplying different cells - or columns of cells - by inserting the
function PRODUCT in the cell for the result, any empty cells count as 1 in
the function...
Say for example, a cell (A1) representing a number of items multiplied with

How can I count the number of blank cells in one column using the criteria
that cells another column is not blank?

I am trying to use a dynamic reference for an OFFSET fucntion but am
not being able to.
The following is the format of my data:
A      B