\1
From the above diagram, can anyone help me with a formula for Accumulated cell in Last Year? Basically, this auto sum has to correspondence with the figures entered into This Year cells (ie. if 2 cells have figures, the Accumulated cells in Last Year will sum up 2 cells only and so forth)
Please help.
P/S : If you difficulties in viewing the above picture... here is a text format
Jan Feb Mac Apr May Jun Accumulated Total
Last yr 100 130 150 250 500 120 380 1250
This yr 200 150 300 650 650
Last edited by gilbert; 07-06-2010 at 05:49 AM. Reason: Problem Solved! Thanks to forum contributors
Thank you in advance,
Gilbert
Here:
(in other words please upload .xls example workbook. Make sure you remove sensible data)
Hi,
The Image is too small to understand.
Please attach a sample file.
__________________
Regards
Rahul Nagar
Founder of www.myshortcutkeys.com.
If you get the answer of your questions then please click EDIT in your original post then click on GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.
Please see the attachment.
Maybe this?
=SUMIF($B$6:$M$6;"<>"&"";$B$5:$M$5)+SUM($B$6:$M$6)
(replace ; with , if needed like this)
=SUMIF($B$6:$M$6,"<>"&"",$B$5:$M$5)+SUM($B$6:$M$6)
Try this
N5
HTH,
Please Login or Register to view this content.
windknife
Alright... thanks for the help zbor and windknife.
The formula "=SUMIF($B$6:$M$6;"<>"&"";$B$5:$M$5)" works fine!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks