=IF(RANDBETWEEN(INT(A1084),$BG$6)>1,$BM$6,IF(RANDBETWEEN(INT(A1084),$BG
$9)>1,$BM$9,IF(RANDBETWEEN(INT(A1084),$BG$10)>1,$BM
$10,IF(RANDBETWEEN(INT(A1084),$BG$11)>1,$BM
$11,IF(RANDBETWEEN(INT(A1084),$BG$12)>1,$BM

I am trying to use a SUMIF function to add figures from column A when the
corresponding entry in column B (which is a date) is less than a year ago.  
To try and make things easier I have a formula in c1 which carries out the
date calculation =TODAY()-365.   I have tried various ...

I have a column (E) that contains names of districts, and column a column (H)
that contains names of teachers and I need to summarize how many times a
certain teacher is connected to a district.  Both columns have multiple
entries in both columns.  What equation would I use to ...

Hi I am trying to use autosum to add up a colum of figures but it keeps
loosing a penny. for example
£551.99
£459.99

OK. So now I tried to sumproduct two other columns using the same
formula...and changing the column letters to match the new count I am looking
for - but it always returns a zero even though there is data there.
I want to find how many kids in each district have been evaluated for ...

for two sample t- test assuming eual variance , i want to know how i use
excel sheet ?

Hey Guys,
Thanks in Advance for your help on this one.
I've got a list about 1500 records long that I want to hyperlink to matching
records on the following page sheet. There are too many to right click and

I need to calculate certain number of employee wages and have Excel
automatically total them up.
My case, I have in cell A3 to input the number of employee. How do I create
an auto row insertion if for example in A3 I put in 10, Excel will auto

I have master list (B3:C8) and I'd like to display a list (G3:G4) based on
cell F3. How I could do that?
Thank you.
    Column B    Column C        Column F    Column G

I have this function =IF(L9="w1",5,0) to test a cell for the text "w1" and
return value 10 if true, value 0 if false. This works as I want it to.
Now I want to test the same cell for text "w2" and return 10 if true.  As a
stand-alone operation this would be =IF(L9="w2",10,0).

This is a tough one i think
been trying to use sum product but have not been able to get it to work
=SUMPRODUCT(--(Sheet1!A3:A6500=Mon!E7:E100),--(Sheet1!D3:D6500=Mon!K7:K100),--(Mon!F7:F100>=Sheet1!E3:E6500),--(Mon!F7:F100<=Sheet1!F3:F6500),--(Sheet1!B3:B6500=Report!B7))
this is ...

I wrote a query in sql and export to excel.  To make sure user can see the
date
I use the convert() function to column A.
 The problem is at other corner of excel a cell B1 referenced to column A

Does anyone have any suggestions on how to hold Macro running until specific
file being updated?
When I run a Macro, in the middle of the process, I would like to hold Macro
running until the periods between the last updated time for specific file and

I need to know what column (or the relative position in the list) the result
of an HLOOKUP came from. Is this possible?

I need a formula that will multiply the value by one of four interest rates,
depending on the size of the value. In other words, if the value is under
$100,000, muliply by rate A. If the value is over $100,000 muliply by rate B.
If over $150,000 muliply by rate C. And if over ...