thanks,I haven't tested the function;
What about my second question?

"Fred Smith" wrote:

One way:

=sumif(a:a,""&date(year(today())-1,3,31),b:b)-sumif(a:a,""&date(year(today()),3,31),b:b)

Regards,
Fred.

"TUNGANA KURMA RAJU" wrote in
message ...
I have a dates in ascending in Col-a, and income amount in col-b.
I need a function that gives me --sum of income earned in this financial
year as on today.(assuming financial year 1st april to 31st march).No
where
the financial year is entered in w/sheet.basing on today's date the
fuction
should calcualte financial year,and other results.
second part of question is -what will the function for last year,basing on
today'date.