Say you enter your "Text" month in C1.

Try this:

=SUMPRODUCT((TEXT(A1:A10,"mmmm")=C1)*B1:B10)

You can add your path to the formula.

FWIW,
You can use the 3 letter abbreviation for the months, so that you don't have
to type the full name, like "September".

If you use Jan, Oct, Sep, ... etc., revise the formula to look for only 3
characters:

=SUMPRODUCT((TEXT(A1:A10,"mmm")=C1)*B1:B10)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Will" wrote in message
...
OK Great that works... Now how can I ask a similar question but this time
I
want to return the sum for the Month of March. I assume I can so
something
like this:
=SUMPRODUCT(--([WorkBook1.xls]Sheet1!$A$1:$A$10<= How do I place the MONTH
HERE??),([WorkBook1.xls]Sheet1!$B$1:$B$10))

I have a cell with the month typed using text "March" do I need to change
this to Date format and enter 03/2007?


"Elkar" wrote:

Try this:

=SUMPRODUCT(--([WorkBook1.xls]Sheet1!$A$1:$A$10=$A$50),--([WorkBook1.xls]Sheet1!$A$1:$A$10<=$A$51),([WorkBook1.xls]Sheet1!$B$1:$B$10))

HTH,
Elkar

"Will" wrote:

ok I cand understand the answers to other similar topics posted here so
i am
going to have to try to explain my self...

I have two .xls sheet (WorkBook1 & Woorkbook2)

In Woorkbook1 on Sheet1 I have in column A incrementing dates...
In Woorkbook1 on Sheet1 I have in column B Total Run Time...

In Woorkbook2 on Sheet2 I have in cell A50 the START date...
In Woorkbook2 on Sheet2 I have in cell A51 the END date...

I am looking for a furmula that will sum the run time between and
including
the START and END dates.

I have succeded in having the formula return a value for a single date
but
not for the sum of the values found winthin a date range...