=SUMIF($A$9:$A48,"<=16",D$9:D$48)
The above works.
But what I need to do is to have the "<=16" get the variable value 16 from a
cell. The cell address with the current value 16 is AH1 and is on the same

I am very new to Excel functions and I can not figure out how to do
this.  I have a column of numbers in A (sheet 1). I want to have column
B have a function that takes the number value from each cell in column A
(sheet 1) and checks if that exact value exists anywhere in column A

We are creating a timekeeping system by division and would like to password
protect worksheets so they are only accessible by the employee whose name is
on it.

Hi, I am using the VLOOKUP function to find a specified value in a column and
then to return another value/text in a onother column but in tha same row.
However, now I want to extend my search of the specified value to include a
search among several columns and when it find a ...

I have several spreadsheets which share data among them.  Frequently, the
"link to" spreadsheet cell indicates an address which is one row off, ie;  
the source date is in F24 but the formula reads F23.  This results in the  
wrong data, of course.  Seems to affect 2 items only... ...

PLease help i'm trying to set up my worksheet to calculate the increase or
decrease percentage from YTDr to LYTD
YTD= 200 LYTD=145 =.38% formula =(a1-b1)/abs(b1) but when I have a zero my
formula wont work please help me to create a formula that could work with

How can I create a formula in a worksheet and/or Pivot Table where I can
figure out an average based on how many certain weekdays fall within that
month.  For instance here is a sample:
1/3/2006    Kenyon Clinic    07398    Chest-- PA & Lateral    12 PM    50

Hello gurus,
Here's my setup.  In the row of a revenue table I have:
(commas are new columns)
Name, Jan, Feb, Mar, Apr, etc

I'm working on a little proggie in excel.
C16 = Some number
B19:B26 = some numbers
C19 =B19+B19/SUM($B$19:B$26)*C16

Hi folks, it’s been a long time since I’ve used Excel, and I’m stuck,
what I’d like to do is to have I7 check the pay code in G7 and then
multiply it by H7  
I suspect I should be using the LOOKUP function with an absolute

I really don't want to use conditional formatting in my spreadsheet.  I want
a certain cell to "shade" a color if it sees text in another cell.  It is a
pain to copy the CF to all of the other cells, as I have about 365 of them to
do.  Can anyone provide an easier answer?

I need to set up of a formula with this info:
1-5 pcs =$5, 6-10=$7, 11-15 = $10. I use the "IF" format, but  I can't
figure it out. Can anyone help?

I have a worksheet with name info from 2 databases. I'm trying to match
names in different columns that have different formats. One has LN, FN,
Initial format, presented in 1 column (Column B), the other has LN,FN
with info in 2 columns (Cols. H:I), all names sorted alpha ascending. ...

I've been using this code and it has been working great:
'Sub Mail_ActiveSheet_Body()
   Dim OutApp As Outlook.Application
   Dim OutMail As Outlook.MailItem

I would like to create a formula that puts the date the file was last
saved/updated.
Any help is appreciated
Hal