I would like to combine the following 2 formulas into 1 formula, yet I can't
seem to find the correct way to do it, if it is possible.
=SUMIF(Invoices!$J:$J,"="&(TEXT(E1,"mmmmmmmmm-yyyy")),Invoices!F2:F2000)
=SUMIF(Invoices!A2:A2000,"="&(TEXT(A21,"00000000")),Invoices!F2:F2000)

I need help with using Excel to do a trend analysis of daily faults and
report the totals on a daily, weekly, monthly and finally yearly basis. First
some background:
I receive a table daily consisting of 25 columns, a variable amount of rows

I messed up big time trying to import my web page from my Desktop to my
laptop so I could do remote publishing.  I have no idea what I did and now my
web site is missing all the borders on the left side dso you can navigate to
my

I have a worksheet in which I have a row with number 1-12 to represent
months.  I a column which contains dates of termination in "mm/dd/yy"
format.  I am trying to create a formula which looks at the month
within the date of the termination column and corresponds that with

Last week I inundated this board with questions about the IF command,
and linking to a table in another worksheet.
Well, I worked out all the bugs and now the sheet looks and acts just
fine!

Easy question for most of you I know but... I need to know.
If there are four names in a cell I would like to make them one under
another. So, instead of:
Matthew, Mark, Luke, John

This is the general idea of what I need to do;
A1 = "A" if B1 > 0
BUT
A1 = "B" if B1 > 0, AND B2 = "YES"

I would like to select from a drop down menu in colum A and after selecting
the required text, colums B and C get populated with additional information.

Hi FSt1: I was looking for a way to link cells on the same sheet and your
response to this post helped, however is there a way to make it so that when
there is nothing entered in cell A1, D5 is blank, mine show up as 0??
"FSt1" wrote:

I am trying to correct a formula I'm entering on Excel.  The formula is:  
=If(A74=E8*E9, ,If(A74<E8*E9,A74+1)); with E8=5, E9=12, and A74=60.  The
result I am getting is "0", and the result I want is a blank cell.  I am
trying to produce a loan amortization table where one can ...

I Have dates in column A and amounts in Column B, Is there anyway to
produce a monthly spend chart from this.
Thanks

Is there any way to have the columns in a column chart (Excel 2003) colored
such that the color of a column depends upon a variable.
Reason is- I want to columns to be gray when they are associated with
p-value >0.05 and blue if they are associated with p-value <=0.05. Right now

I have received some info through this posting, but it is not working how i
want to.
Hoppefully someone can help me further?
I have a Macro in a Module (Workbook_save)

Looks like there's a posting problem again.
I'm using OE and I'm not getting any messages posted through CDO.

Hi. i am trying to set spreadsheets of holidays for each peasron
i have tryed to use DATEDIF formula but seems to be it is not what i need
as, for example, if person took days off on 16/03/07 and 17/03/07 it gives me
result as only 1 day. what formula shell i use?