ciao
in the sheet1 I have these data
a1 babbo 10 01/09/05 (1 september 05)
a2 mamma 15 02/09/05
a3 babbo 15 30/09/05
a4 babbo 20 10/11/05
a5 zio 10 10/11/05
a6 zio 20 01/12/05
---- -------- ---
a101 babbo 20 01/01/06
a102 babbo 10 01/01/06

with 3 combobox, respectively day, month, year from userform
selecting day+month+year; or month+year; or year only
how I can obtain in the sheet2 if I want 01/09/05:
babbo 10
mamma 15
or for 9/05 (all sept 2005)
babbo 25
mamma 15
or for 05 (all year 05)
babbo 45
mamma 15
zio 30
or for all (year 05+06)
babbo 75
mamma 15
zio 30

I hope to have explained well, very many thanks

ops, excel 2003