I have to formulas:
1) 1 = C/252*days(1)*d(1) + c/252*days(2)*d(2) +  c/252*days(3)*d(3) +
d3
and

This will be easy for most but not me.  Here goes:
I want Excel to simply generate a random number between 1 and 75 ( I know
how to do this part) like in BINGO, if the number is between 1 and 15, show
"B15" if 15 was to be generated.  Since I in BINGO contains the range

I have a list of 6000 entries in excel of which 4 namely x1,x2,x3 and x4 are
used repeadily and i want to make a drop down list to make my search easier

Based on the attached table, I'm trying to show a total for:
if column b is "outside services" AND column c is "1", then take the
total from column a.
(In other words, I'd like the function to know to add cells a2, a3 and

I have this page setup with formulas for each row to keep totals but when I
add a number to nest row it adds that number and the number from the previous
row how do I get around this? I will mention I am new at this and it has been
learn as I go.

In Excel, how do I total the absolute value of a column of numbers without
invoking 'abs' function individually on each cell in the range?  (e.g.
abs(a1)+abs(a2)+abs(a3)...)

I want to repeat cells (titles) in multiple sheets referencing the text from
sheet1.  However when I properly type in the formula, it is the formula that
displays, not the text.
Any suggestions?  Is the worksheet protected in some way?  It has been

I have a range F52:H73, I am trying to count the numbers>0,and <125.
I came up with
=COUNT(IF(F52:H73<>0<125,F52:H73))
Range looks like

I have 6 fields of data all in column A but each row the data is spaced out
differently, not even close. The fields themselves do not have any spaces but
obviously there various spacing beteen the fields. The first feild is flush
left but all the others are all over the map. Is ...

how do I write in a substitution of a comma?  SUBSTITUTE does not seem to
like it when I just type SUBSTITUTE(reference, ",","_").  I need it
substituted with an underscore.
Thanks.

I am trying to count numbers greater than or equal to a specific number
(column heading) and be able to copy down or across.
In a range F52:H73
Criteria- Labeled

I have the following Sheet1 containing the subscriptions for Providen
Fund Accounts
A               B         C        D        E    ...    N         O        
1  Name       A/c No  Jan-yy   Feb-yy   Mar-yy   upto Dec-9

I had a consolidated worksheet from 01/01/05 to current,and was requested to
sort by name/date and then subtotal all entries w/o saving the consolidated
one. Is there a way to recover the original one?

I have a start date and end date
I need to check if the month and year fall within the range
Start Date & End Date are in sheet 1
Date to check is in sheet 2

I have a file containing a list of names, and the quantities associated
with that person for that particular week.
e.g.
Week1.xls     |