Using the formula in excel   = sumproduct(--
(left(A1:A200;1)="2");c1:c200)
it means that take the first digit in column a  if this i equal to 2
then sumarize C column

If I want to set up a 3-D formula that is not just between worksheets in the
same workbook, but a formula that is between different workbooks, how do I do
it?

I have 20 consecutive rows each having 12 values in 12 consecutive
columns in each row. Now i want to write a procedure where I shall be
copying each row and pasting it on a different row. one at a time.
After the procedure has run thru all the 20 rows, it stops.

Have problem with inserting cell address inside formula
If we use formula wizard to make simple sum from cell A1 to A2, our
formula on formula window looks like(independ of language version of
course ;) ):

Cell C12 has this formula:   COUNTIF($E12:$AI12,$C$5)
What modifications should be done so as it will count the values equal to C4
(in addition to C5).
Khalil

I would like to copy the sheet name into a cell in the same sheet in a way
that if the sheet name is changed the content of the cell is changed too.
Is there a function to do this?
Thank you

Hi, I'm using the array formula below in a cell.
{=SUM((B2:B192="Salo, Steve")*(J2:J192>0))}
It works well in columns where there are data that meet the criteria, but in
this column J where there are none with values above 0, it counts all the

I'm trying to come up with a daily cost sheet.  What I've done so far
is develop a tab on the spreadsheet that has all the information, that
I want to retrieve.  Now, what I want to do is develop a  "summary
page" that retrieves information by date.  So, what I did was come up

I need to see if there is a way to reference a value in a worksheet
that is dependent on the name of the worksheet that is in an active
cell on the first worksheet.
Summary Sheet is like this:

I have a cell which sum a bunch of cells containing an elapsed time.
The sum totals to more than 24 hours.
I have to a cell with a cost per hour and I need to caclculate the
total cost.

I had a complex workbook, lots of tabs with a company logo on the top
(in the worksheet not the header).  Any time I accessed the "PrintArea"
"PrintPreview" or other page layout features of Excel2007 the worksheet
would lock up and the inserted graphics would disappear or blink ...

Our accounting software creates an excel report that contains a link
to an image. (file://H:\xxxxx\xxxx\xxxxx.tif) for example.
The problem is we want to replace the path to the image with something
that will point to a folder on a dvd for example.  We will not be able

I have an excel file, which I can't opened because it has already too many
different cell formats, which I solved by formatting, but
is there a way how can I see a statistic of the number of formats used in
one file (out of 4000 I think), in order not to find my self in a same

i have 1 main worksheet and 78 secondary worksheets labelled as week1 to
week78.
how do i add totals from cell L5 from all sheets to my Main sheet
The total should be shown in the main sheet

Here is what I have
Col A     Col B            Col C
1310    3    3,463.00
1315    3    740