summing periods

[dave h]

hi

is there a way to sum period amounts for each year without using a pivot
table- data is loan amortisation is any body is interested and uses
functions to create the amount data


data file is periodic 1 st columns periods then data in second column

for example:

periods amount

p1-2004
p2-2004
etc
etc
out to 2025

any help would be groovy!

dave

 

[Frank Kabel]

Hi
use SUMIF. e.g.
=SUMIF(A:A,"p1-2004",B:B)

 

[Rob Phillips]

Hi dave,

I would suggest using SUMIF:

=SUMIF(range,criteria,sum range)

Rob.

 

[dave h]

thanks guys worked a treat