Calculate Sum of Range for current year

[Frozen001]

Hello,

I have an excel spread sheet to track fuel costs. I want to be able to be able to calculate the year to date total cost as well as possible the prior years cost. Is there a way to do this?

Thanks,

Lou

[arthurbr]

Hi and welcome to the board

Depending on the data layout and your needs several solutions are possible.


To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[Frozen001]

Here is an exmple with 3 rows. My actual spread sheet is much mor complex, but if I can get it to work on this, I can make it work on my actual sheet.

All I want to do is have a spot that says Year to date cost, and another that says previous year cost.

[arthurbr]

One possible solution is =SUMPRODUCT((YEAR(A2:A4)=2010)*D2:D4)

Adapt ranges as needed, but they must have the same length.