I want a cell from one sheet to return the sum of various cells in another
sheet.
For Example:
Sheet 1:

I have the array formula:
=SUM(IF((Sheet1!$Y1:$Y5809="26")*(Sheet1!$AJ1:$AJ5809=CREDIT!$A4),1,0))
It works fine except I want it to reference the cell that the number 26
is in rather than having to have it in quotes, i tried this, but don't

I’ve used this formula successfully  
=SUMPRODUCT(--(I1:I18="GTB1"),--(J1:J18=0))
What I would like to do is look for “GTB1” and “LOB1” in column I
I tried  

I am using several drop down lists in a worksheet.
Some of the drop downs show the items starting at the top of the list,
others start half way through a list.
Can i make then all start with the first item on the list?

I'm trying to create a drop down menu in excel, but for the life of me I
can't figure out how to do it.

I have created a formula:  =IF(G10="N","=M10",IF(G10="Y","=.95*M10")) to
adjust a salary dependent on whether salary savings have been taken (Y) or
not (N).  If they have been, then I want to multiply the previous cell by .95
to adjust the salary.  The formula works to the point ...

Computer crashed so re-installed Office 2003. Ticked for updates and now find
that the colours are different e.g. I can no longer get a vibrant red. Using
this new "Custom" option still leaves me with a red that is nearer black.
Has anyone got the answer please?

I have worksheet for periodical (serial) payments.
Column A - payment starting date, in each row different, formated as
"dd.mm.yyyy"
Column B - type of payment (yearly, biannualy, quarterly, monthly)

I have an extensive spreadsheet that contains tables of data for account
names by year.  I would like to have a cell return data from the tables when
the account name and applicable year are typed into a worksheet.  For
example, in workbook 1, separate 4 x 3 tables are set up for ...

im looking for a way to give totals of the number of occurances of
strings in a column.
the column i have has a set range of possible string values (which can
be referenced in a seperate sheet) and im looking for a way to produce

I would be most grateful for any help with the following please.
In Column D4 to D44 I have numbers such as.
100
101

I want to find and highlight any cells that contain identical content.

Help please! I used the following formula in the last column DRYBU
=IF(B6<=15.4,B6/56,(100-B5)/84.5*B5/56) in the table below. The formula
in WETBU just divides the NET column by 56.  The formula is working
when the (MOIST column B6) is 15.5 and above but when it is (below 15.4

I am trying to use the above fuctions to match a price from an price /  
weight matrix, where the weights are between a lower and upper value e.g 60
gms to 99 gms = $0.42, 100 gms  to 149 gms = $0.60. The functions work when
the input weight EXACTLY matches weights of say 60 or 99 ...

I have a column of data in the form
a
a
a