Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
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" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
Thanks,
Fred ,its working. "Fred Smith" wrote: 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" wrote in message ... 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum a column range basing on financial year.
Glad to hear it. Thanks for the feedback.
Fred. "TUNGANA KURMA RAJU" wrote in message ... Thanks, Fred ,its working. "Fred Smith" wrote: 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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
year quarters === Financial Year | Excel Discussion (Misc queries) | |||
How to compare a date with financial year | Excel Discussion (Misc queries) | |||
Basing Average function range on Date? | Excel Discussion (Misc queries) | |||
year function and financial years | Excel Worksheet Functions | |||
formula to calculate the average of a range basing on condition | Excel Worksheet Functions |