Trying to count only expenses for a specific month

[thespasticone]

I am putting together a cashflow spreadsheet. Multi tab.
In one tab I have one-time expenses like this
Col A Col B Col C
Travel $1000 Jul
Expo $500 Aug
Denver $1500 Jul

If I put in this formula
=SUMIF('up-coming one-time expenses'!C:C,"=jul",'up-coming one-time expenses'!B:B)
Then the value of $2500 is returned. PERFECT!
However, If I put in this formula
=SUMIF('up-coming one-time expenses'!C:C,"=A2",'up-coming one-time expenses'!B:B)
no value is returned
In this instance, the value of A2 is "Jul", but it is returned from a reference, the formula of A2 is
=Snapshot!M1
To confuse the matter more, the values of snapshot m1 are given by a drop down, and the actual value is 7/1/2014, but the dropdown is for months

BASICALLY what I need to do is somehow adjust
=SUMIF('up-coming one-time expenses'!C:C,"=A2",'up-coming one-time expenses'!B:B)
So that it only returns the TEXT VALUE of a2, rather than the formula.

I have no idea if I am explaining myself properly but please help if you can. Thanks!

 

[Weazel]

not sure I'm understanding everything, but, if you are trying to reference A2 as Jul then try....

=SUMIF('up-coming one-time expenses'!C:C,"="&A2,'up-coming one-time expenses'!B:B)

you can try

=text(Snapshot!M1,"mmm")

to convert A1 to Jul as text

 

[ghrain22]

[Qoute]=SUMIF('up-coming one-time expenses'!C:C,"=A2",'up-coming one-time expenses'!B:B)[/Qoute]

The problem with this is that it's look for the value to be equal to "A2" not the VALUE in A2. When you surround things in qoutes it reads it as a string, so your not referencing that cell. It should look more like "="&A2.

 

[thespasticone]

not sure I'm understanding everything, but, if you are trying to reference A2 as Jul then try....

=SUMIF('up-coming one-time expenses'!C:C,"="&A2,'up-coming one-time expenses'!B:B)

you can try

=text(Snapshot!M1,"mmm")

to convert A1 to Jul as text

Your first suggestion nailed it!