Hi

How to sum values from column B in column C according criteria date
from column A ?
I mean - Column A are date, Column B are values and Column C is the
place where I want to show the amount.

Thanks in advance
Osmario

On Jul 9, 8:28*pm, "
wrote:
Hi

How to sum values from column B in column *C according criteria date
from column A ?
I mean - Column A are date, Column B are values and Column C is the
place where I want to show the amount.

Thanks in advance
Osmario

Before/after examples

On 10 jul, 11:02, Don Guillett wrote:
On Jul 9, 8:28*pm, "
wrote:

Hi

How to sum values from column B in column *C according criteria date
from column A ?
I mean - Column A are date, Column B are values and Column C is the
place where I want to show the amount.

Thanks in advance
Osmario

Before/after examples

See data below

A B C
date value
14/01/11 400,00
16/01/11 402,00
18/01/11 404,00
20/01/11 406,00
22/01/11 408,00
24/01/11 410,00
26/01/11 412,00
28/01/11 414,00
30/01/11 416,00
01/02/11 418,00
03/02/11 420,00
05/02/11 422,00
07/02/11 424,00
09/02/11 426,00
11/02/11 428,00
13/02/11 430,00

I need a formula to sum in column C cells those match criteria January
or February or other month oy the year.
Thanks
Osmario

Hi Osmario,

Am Sun, 10 Jul 2011 13:02:58 -0700 (PDT) schrieb
:

See data below

A B C
date value
14/01/11 400,00
16/01/11 402,00
18/01/11 404,00
20/01/11 406,00
22/01/11 408,00
24/01/11 410,00
26/01/11 412,00
28/01/11 414,00
30/01/11 416,00
01/02/11 418,00
03/02/11 420,00
05/02/11 422,00
07/02/11 424,00
09/02/11 426,00
11/02/11 428,00
13/02/11 430,00

I need a formula to sum in column C cells those match criteria January
or February or other month oy the year.

try it with a pivot table. Drag date to rows and value to values and
group date to month.


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

" wrote:
A B C
date value
14/01/11 400,00
16/01/11 402,00
[....]
11/02/11 428,00
13/02/11 430,00

I need a formula to sum in column C cells those match
criteria January or February or other month oy the year.

You could write:

=SUMPRODUCT(--(MONTH(A1:A100)=1),B1:B100)

The double-negative (--) converts TRUE and FALSE to 1 and 0, which
SUMPRODUCT requires. The month number 1 represents January.

Alternatively, if C1 contains a date like 01/01/11 (Jan 1 2011), which you
can format as Custom mmmm if you want to see January, you could write:

=SUMPRODUCT(--(MONTH(A1:A100)=MONTH(C1)),B1:B100)