Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.


apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40


Thanks in advance for any help.

=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message
...
Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.


apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40


Thanks in advance for any help.

On Jun 24, 3:51 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message

...

Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.

apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40

Thanks in advance for any help.

Thanks for the reply Bob. However what you proposed won't work. I
should have noticed it when I posted, but the SH & LS are the initials
of the sales person.

So what do you need instead?

--
__________________________________
HTH

Bob

wrote in message
...
On Jun 24, 3:51 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message

...

Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.

apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40

Thanks in advance for any help.

Thanks for the reply Bob. However what you proposed won't work. I
should have noticed it when I posted, but the SH & LS are the initials
of the sales person.

I need a formula that is able to total the dollar value of a specific
product sold in the course of a specific year. There are up to 5
different products that can be sold, so for example purposes the
products that can be sold are Apples, Oranges, Cherrys, Lemons, and
Grapes. This started back in August 2007 and it will run for many
years to come. For instance I need to know the total dollar amount of
apples sold in 2007. So, when 2009 comes around I'll need the formula
able to be changed to total up the same info as in 2008 & 2007, but to
not include those years in the totals. Hope this sheds more light on
my situation.

Thanks again.

On Jun 25, 3:16*am, "Bob Phillips" wrote:
So what do you need instead?

--
__________________________________
HTH

Bob

wrote in message

...



On Jun 24, 3:51 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message

....

Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. *This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. *What I need is a formula that will provide me the
dollar amount spent on a product in a given year. *I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. *I
really hope I've explained this well enough. *Here's a small example
of the sheet.

apples * LA * * * * * *SH *11/20/2007 *$1,464.00
oranges MT * * * * * *LS *12/3/2007 * *$972.00
cherrys *IN * OEP * SH * 1/24/2008 * $662.40

Thanks in advance for any help.

Thanks for the reply Bob. *However what you proposed won't work. *I
should have noticed it when I posted, but the SH & LS are the initials
of the sales person.- Hide quoted text -

- Show quoted text -

So isn't it just

=SUMPRODUCT(--(rng_product="Apples"),--(YEAR(rng_dates)=2008),rng_Dollars)


--
__________________________________
HTH

Bob

wrote in message
...
I need a formula that is able to total the dollar value of a specific
product sold in the course of a specific year. There are up to 5
different products that can be sold, so for example purposes the
products that can be sold are Apples, Oranges, Cherrys, Lemons, and
Grapes. This started back in August 2007 and it will run for many
years to come. For instance I need to know the total dollar amount of
apples sold in 2007. So, when 2009 comes around I'll need the formula
able to be changed to total up the same info as in 2008 & 2007, but to
not include those years in the totals. Hope this sheds more light on
my situation.

Thanks again.

On Jun 25, 3:16 am, "Bob Phillips" wrote:
So what do you need instead?

--
__________________________________
HTH

Bob

wrote in message

...



On Jun 24, 3:51 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message

...

Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.

apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40

Thanks in advance for any help.

Thanks for the reply Bob. However what you proposed won't work. I
should have noticed it when I posted, but the SH & LS are the initials
of the sales person.- Hide quoted text -

- Show quoted text -