excel - Sum quarter data according to months completed -

-

i need sum quarter data kept in column c2 w2. in cell w1 number of months passed, current purpose 7. sum in cell w2. 7 months have passed, hence need sum c2, d2 , 1/3* e2 , show value in w2. e2 multiplied 1/3 because 7th month 1/3rd of 3rd quarter. quarters financial quaters, doesn't start fy start.

hope clear. if point me in right direction appreciated.

try formula c2

=if(w$1<3,0,sum(c2:index(c2:w2,w$1/3)))+index(c2:w2,w$1/3+1)*mod(w$1,3)/3

that calculates how many whole quarters need included, partial ones. if function deals small c1 values


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more