sum a column range basing on financial year.

[TUNGANA KURMA RAJU]

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.

 

[Fred Smith]

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]

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

 

[Fred Smith]

Why don't you test it out to see if it works. Then we'll work on your second
question. I expect you'll find if the formula works for the current fiscal
year, it won't be too hard to change for the previous year.

Regards,
Fred.

 

[TUNGANA KURMA RAJU]

Thanks,
Fred ,its working.

Why don't you test it out to see if it works. Then we'll work on your second
question. I expect you'll find if the formula works for the current fiscal
year, it won't be too hard to change for the previous year.

Regards,
Fred.

 

[Fred Smith]

Glad to hear it. Thanks for the feedback.

Fred.

Thanks,
Fred ,its working.