Not sure if this is the function for the job but I need to have SUMIF
compare values in multiple ranges/columns and add if the values match
in those columns
e.g.

Hi, I am trying to find out if there is a function I can use in a summary
sheet that will pull data from an unknown sheet name. In other words I would
like to have the summary sheet in place and as I add new worksheets it will
pull data from them without having to go back and ...

I am using a password cracker for an excel spreadsheet. It is not getting
the password but I do get this message:-
Run time error91
Object variable

I'm like to create a function to sum data from worksheets that have yet to be
created. I'm attempting to automate the import of new data into new
worksheets. I have considered creating hidden worksheets and ensuring that
the new worksheets are always between the hidden worksheets ...

I've got a workbook with multiple sheets in it.  The first one is a huge file
(35 columns and 1,500 rows) with complex functions.  Subsequent sheets are
linked to the first.  To illustrate my question, I'm using a simplified
scenario:

I have two columns range(A1:B1443).  All I need to do is take the value of B1
and compare it to every item in column A.  If this value appears in column A
at all, I would like C1 to return a value of 1, and if it does not appear I
would like C1 to return a value of 0.

I have an excel 2003 document with 12 pages of all employees listing the
hours and
minutes used on each job.  I have a grand total at the end, but for some
reason when I tell excel to add the times together the figures don't match to

I have a large spreadsheet that has information formatted like this:
Item Code    Item Description 1                 Lot Code 1    Lot Code 2
00011336    GSX RS CHEW  CS                98680              200805
                                                          98798

is there a limit to the number of nests you can have in a nested
IF(ISNUMBER(SEARCH)) functions?
For example, I have one that works properly with 6; for example:
=IF(ISNUMBER(SEARCH("jon",AC2)),"jon",IF(ISNUMBER(SEARCH("bill",AC2)),"bill",IF(ISNUMBER(SEARCH("tom",AC2)),"tom" ...

I would like a cell to be locked or unfillable based on the results of
another cell.
For example:
Column B has a formula that the results are "" or "x".

please consider the following example:
a    c    1
a    d    2
Why is (as matrix formula)

I want to make a function in excel 2003 that likes the function "sumifs" in
excel 2007.
Anyone please help.

After new install of Office 2000 , the working sheet starts on the left side
, (column A on the left) and I do not have the option to change it to start
from right (column A to start from the right )

I have a spreadsheet with many cells set to Validate - List.  The drop down
lists work fine... UNLESS someone comes along and "Pastes" something into the
cell at which time, the pasted data is there, the Validate does not prevent
it and the drop-down list is no longer available ...

I have a list of Folders and the numbers of pictures they each contain. I
would like to know if it is possible to use Excel to split this list into a
choosen number of groups whose values are as near to equal as possible, so
for example say I have twenty artist with a total of ...