I need help writing a formula
if range E18:E23 is greater than 40, I want the number E18:E23-40 entered
into the cell, if false 0

I need to work out the days left till the end of a certain date fro
today and then add any holidays to that count if there are any betwee
now and then. My result shout be a number.
I live in South Africa so excel does not have the holidays her

I have a formula set up to count the number of e-mails answered by category
for each month.  The formula being used is:
=SUMPRODUCT(--(MONTH(Pivot!$E$8:$E$1589)=MONTH($B$1)),--(Pivot!$E$8:$E$1589<>"")*(Pivot!$J$8:$J$1589=A24))
Where column E contains the date the e-mail was ...

I have a sheet of data dumped from a SQL query that is used to populate a
report.
Lets say that the data looks like this
    A|B|C

I have data that is entered from a report that is done periodically and don’t
want users to use the spreadsheet after a specific date (this date is entered
into a header).  So I want to be able to look at the current date and compare
it to the header date and if the current date ...

Hi I want to setup a macro that will send information from Sheet2 cell A5 to
Sheet1 cell B4.
Can anyone please help with the formula required to send the reqd info?

Say I have sheet 1, cell a1 painted red and value 100. In sheet 2 I want to
have the same value and format.
I do =+sheet1!a1, so I get the value, but how I get the color?
Thanks in advance.

Need help to write formula or suggest a way of doing.
When Cell F3 is not equal to "CURRENT"
then where (G3:G10) contains X
change X to A.

Hello, people...
I'm having a heck of a time devising a formula for a seemingly simpl
task, which I will outline below:
I've got a page in my workbook named "Schedules".  On this page, B1:IU

I am working on an excel spreadsheet where I have a table of 120 customers
and their revenue in year 1 and year 2, is there a formula that I can write
to extract the top 5 customers(in terms of revenue) from the table?

I don't think this is very hard, but I'm not sure how to approach it.
Basically I have an 8 bit binary code that represents a decimal value
between 0 and 255, and each of the 8 bits represents a different color.  By
either using the decimal or binary number, I need to output the ...

Driven mad by having to resize pivot tables constantly, printing and
reprinting to ensure they fit to a page and are readable. There needs to be
some way of setting the actual print size so that you can read its printed
format in the size that it will be, with a view on how much ...

I need to sum some numbers and all these are linked to accounts.
Lets say I have accounts in column a:
4001
4002

I have on sheet1 a couple thousand rows of data.  A:A contains dates,
B:B contains ID numbers.
on sheet2 I need to know how many instances an ID number shows up on a
selected date.  The specified ID number will be in sheet2, A2; the

I will post the two formulas I am using now and I hope someone can help
me figure out how to make it into 1.  Thanks in advance.
#1               =COUNTIF(location, "shop")    total=20
#2               =COUNTIF(date,">"&B10)-COUNTIF(date,">"&B11)