Formula Help

[VbaHell]

Hello all

I need help please on a formula

Column "L" has sales values
Column "AT" has a TEXT value in this format "Jan. 2015" this value in for every month "Feb. 2015", "Mar. 2015" up to the current month

I am trying to work out a formula to add up Year to date 2015 (Last year against this year)

So for this month it would be Jan. 2015 + Feb. 2015 + Mar. 2015

Is this possible please

 

[Jonmo1]

How does column AT get the TEXT value of the date?
Is it a formula that's referring to another column that has actual date values?
It would be simpler to refer to THAT column instead..

 

[steve the fish]

You found a reason why a date shouldn't be text. You can always format it to show how you want it to look while keeping it a true date. However heres a couple of ways:

=SUMPRODUCT(SUMIF(AT:AT,{"Jan. 2015","Feb. 2015","Mar. 2015"},L:L))
=SUMPRODUCT(--(RIGHT($AT$2:$AT$100,4)="2015"),$L$2:$L$100)

 

[VbaHell]

Hi Jonmo1

Column "E" has the actually date in date format

02/01/2015

<tbody>
</tbody><colgroup><col></colgroup>

 

[Jonmo1]

Try

=SUMIFS(L2:L100,E2:E100,">="&DATE(2015,1,1),E2:E100,"<"&DATE(2015,MONTH(TODAY())+1,1))

 

[VbaHell]

Jonmo1

This works great

Many Thanks