I'm still unable to get the basic SUMIF formula to work:
SUMIF(Dates,"="&StartDate,Values)

My exact formula reads like this: =SUMIF(C6:C429,"="H3,D6:D429) where H3
is the Start date. C column is dates, D is Value. It says there is an
error. It lets me do it if I change the criteria to this
=SUMIF(C6:C429,"=H3",D6:D429) but it just returns 0. Thanks for your
help.

"Ron Rosenfeld" wrote:

On Thu, 28 Sep 2006 15:49:02 -0700, Woody13
wrote:

I realized I need to include =start date cell all in " ", but then the
answer came back zero. It seems as if SUMIF is meant to work when the
criteria is in the cells you are summing (VALUES) and not in the DATES. Is
there a way to toggle how the formula looks at criteria? Thanks

No. That's not it.

The problem is a typo in what I had posted:


=(SUMIF(Dates,"="&StartDate,Values) - SUMIF(Dates,""&EndDate,Values))
/(COUNTIF(Dates,"="&StartDate) - COUNTIF(Dates,""&EndDate))


Here are the data I tested it on:

3/1/2006 StartDate
3/31/2006 EndDate


Dates Values
5-Jan 1
6-Jan 2
4-Mar 3
5-Mar 4
4-Sep 5
5-Jun 6


Result: 3.5

I used NAME'd ranges, but you can use direct references.
--ron

On Thu, 28 Sep 2006 17:14:01 -0700, Woody13
wrote:

I'm still unable to get the basic SUMIF formula to work:
SUMIF(Dates,"="&StartDate,Values)

My exact formula reads like this: =SUMIF(C6:C429,"="H3,D6:D429) where H3
is the Start date. C column is dates, D is Value. It says there is an
error. It lets me do it if I change the criteria to this
=SUMIF(C6:C429,"=H3",D6:D429) but it just returns 0. Thanks for your
help.

Woody,

You left out the ampersand (concatenation operator)

You have:

"="H3

it should be:

"=" & H3


--ron

THANKS!!!

"Ron Rosenfeld" wrote:

On Thu, 28 Sep 2006 17:14:01 -0700, Woody13
wrote:

I'm still unable to get the basic SUMIF formula to work:
SUMIF(Dates,"="&StartDate,Values)

My exact formula reads like this: =SUMIF(C6:C429,"="H3,D6:D429) where H3
is the Start date. C column is dates, D is Value. It says there is an
error. It lets me do it if I change the criteria to this
=SUMIF(C6:C429,"=H3",D6:D429) but it just returns 0. Thanks for your
help.

Woody,

You left out the ampersand (concatenation operator)

You have:

"="H3

it should be:

"=" & H3


--ron

On Thu, 28 Sep 2006 18:36:01 -0700, Woody13
wrote:

THANKS!!!


You're welcome. Glad you got it working.
--ron