sum a column range basing on financial year.

  • Thread starter Thread starter TUNGANA KURMA RAJU
  • Start date Start date
T

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.
 
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.
 
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.
 
Thanks,
Fred ,its working.

Fred Smith said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top