YTD累计Excel 2010 [英] YTD Totalization Excel 2010
问题描述
确定我有一个情况
我们有帐户的每月数据
Ok I have a situation We have monthly data for accounts
May June July Aug Oct Nov Dec Jan Feb Mar April
Jackson Hall 2 5 8
Goolrick Gym 2 4 10 15 17
Brent Hall 1 6
每个月都在自己的列。那么每个帐户有一年到目前为止。
Each month is in its own column. Then each account has a year to date total.
我想做的是做一个名为Total的标题。在本专栏中,我希望它拉出最近的数据条目。
What I want to do is make a heading called Total. In this Column I want it to pull the most recent Data entry.
我需要总计列从7月份的杰克逊中提取8个,从10月份的Goolrick 17个6月6日为布伦特厅。
I need the Total column to pulls the 8 from July for Jackson, the 17 from October for Goolrick and the 6 from June for Brent Hall.
Total
8
17
6
推荐答案
根据扩展表的大小,最简单的方法之一是在最后一个条目之后使用像*一样的东西
depending on the size of the spread sheet one of the easiest ways to do it is to use something like an * after the month with the last entry.
Jackson Hall 2 5 8 *然后使用以下公式
Jackson Hall 2 5 8 * and then use the following formula
= OFFSET(A2,0, MATCH(*,A2:C2,0)-1)在你的决赛桌。
=OFFSET(A2,0,MATCH("*",A2:C2,0)-1) in your final table.
还有其他的方式来做,但会涉及到倒转你的表,所以每月插入数月。 Excel从左到右,而不是从右到左。
There are other ways of doing it but would involve reversing your table so the months were inserted each month. Excel works left to right, rather than right to left.
同样,还有其他更复杂的方式来做,但这可能是最简单的。
Equally there's other more complex ways of doing it but that might be the easiest for you.
这篇关于YTD累计Excel 2010的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!