• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Count and Sum

I

Injinia

Member
Hi,


In the attached file, I would like to have a formula in cell AA that does the following:


checks the grey cell for the mark x and sums the 12 preceding months before that point. So like in

north, sum would be 1.2011 - 12.2011

South, sum would be 3.2011 - 2.2011

East, sum would be 2.2011 - 1.2012


https://www.dropbox.com/s/85avkh1cg9amqdi/Sum%26Countif.xlsx


Regards,

Injinia
 
Injinia


AA3: =SUM(OFFSET(B3,,MATCH("x",$C$2:$T$2,0)-12,1,12))

AA4: =SUM(OFFSET(B4,,MATCH("x",$C$2:$T$2,0)-12,1,12))

AA6: =SUM(OFFSET(B6,,MATCH("x",$C$5:$T$5,0)-12,1,12))

AA7: =SUM(OFFSET(B7,,MATCH("x",$C$5:$T$5,0)-12,1,12))

AA9: =SUM(OFFSET(B9,,MATCH("x",$C$8:$T$8,0)-12,1,12))

AA10: =SUM(OFFSET(B10,,MATCH("x",$C$8:$T$8,0)-12,1,12))
 
You must log in or register to reply here.
Back
Top