Difficult sum query - I'm s(t)umped!

[ClaireFin]

I have a set of data which contains the following:

2008	1
2009	2
2010	0
2011
Charge	XYZ

<tbody>
</tbody>

This data repeats, so sometimes the date with the last value in will be 2011, and sometimes the only value will be in the earliest i.e. 2008.

The output I need is:

2008
2009	Sum all XYZ (where last value in 2009).
2010
2011

<tbody>
</tbody>

Does anyone have any ideas how to do this?
Thanks so much

 

[DebugGalpin]

Hard to tell from the data but an if max would work I think

if (Max of column A = Cell A row whatever, sumifs(ColumnB, Column A, 2009),0)

 

[ClaireFin]

Hard to tell from the data but an if max would work I think

if (Max of column A = Cell A row whatever, sumifs(ColumnB, Column A, 2009),0)

Hi @DebugGalpin

Thanks for your help!

The thing is I need it to sumif the charge amounts, not the amounts displayed next to the date value.

For example, the data sample would look like:

2009	1
2010	2
2011	3
2012	4
2013	0
Charge	100
2009	5
2010	0
2011	0
2012	0
2013	0
Charge	350
2009	1
2010	2
2011	0
2012	0
2013	0
Charge	12
2009	8
2010	0
2011	0
2012	0
2013	0
Charge	100

<tbody>
</tbody>

The output would need to be as follows:

2009	450 (350+100)
2010	12
2011
2012	100
2013

<tbody>
</tbody>

Any ideas?

 

[DebugGalpin]

Becomes somewhat harder now with the way the data lies. We need a board MVP on the case here... sorry.