complex excel situation

G

garrettinil

I need excel to take the date in column B and the percentage in column L and
add the percentages for each month and separate the sum by month. I then
need to create a line chart to reflect the data.
 
M

Marcelo

hi garrentinil

use

=sumproduct(--(month(b2:b1000)=1,l2:l1000) for Jan
=sumproduct(--(month(b2:b1000)=2,l2:l1000) for Fev
....
=sumproduct(--(month(b2:b1000)=12,l2:l1000) for Dec

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"garrettinil" escreveu:
 
D

David Billigmeier

Assume your month values are located in column M, place this in column N (for
example) and drag down. Then create your line chart on the resulting data.

=SUMPRODUCT(--(MONTH(B1:B100)=M1),L1:L100)
 
G

garrettinil

let me try to show what i'm doing:
COLUMNS
B L T V
Date % Month Total Accumulated Total
2/8/06 10 Jan - 0 0
2/28/06 10 Feb - 20 20
4/12/06 18 Mar - 0 0
4/31/06 38 Apl - 56 76
_________________

I need the formula for Columns T & V.

Thanks,
 
M

Marcelo

on column V

V2 ="Jan - "&sumproduct(--(month(B1:b100)=1),(l1:l100))
v3 ="Feb - "&sumproduct(--(month(B1:b100)=2),(l1:l100))
etc

on Colum T

T2 =right(v2,len(v2)-find("-",v2)))+0
T3 =right(v2,len(v2)-find("-",v2)))+v2
copy it down



--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"garrettinil" escreveu:
 
Top