Sum IF Less than or Equal to not working....So lost

[bkrupa]

Hi Everyone,

I have been trying a SUMIFS string and have identified the problem within it. I am trying to return a year to date total for column J where the weeks are in column F. If I use equal to M30 it works and returns the sum of the values for the current week but I would like it to return the values for the current week AND all the weeks before it creating a YTD total. For some reason if I put in the less than command it returns nothing

Below is the formula that is not working

=SUMIF(F12:F3443,"< ="&M30,J12:J3443)


It will eventually be plugged into this:

=SUMIFS(Budget!$J$12:$J$3443,Budget!$E$12:$E$3443,'Meat TF'!$Q$9,Budget!$F$12:$F$3443,"> ="&$R$5,Budget!$H$12:$H$3443,'Meat TF'!$Q$10,Budget!$I$12:$I$3443,'Meat TF'!$Q$8)

Thank-you so much in advance!

 

[Marcelo Branco]

It seems there is an extraneous space in your formula
=SUMIF(F12:F3443,"< ="&M30,J12:J3443)

See if this works
=SUMIF(F12:F3443,"<="&M30,J12:J3443)

M.

 

[bkrupa]

It seems there is an extraneous space in your formula
=SUMIF(F12:F3443,"< ="&M30,J12:J3443)

See if this works
=SUMIF(F12:F3443,"<="&M30,J12:J3443)

M.

I tried that too! Another thread recommended the space there so I put it in.

Thanks so much though!

 

[Marcelo Branco]

I tried that too! Another thread recommended the space there so I put it in.

Thanks so much though!

No, the space is wrong!

M.

 

[bkrupa]

I figured it out....I think! For some reason the less than command will not work if the cells are a formula but if I paste values it works....

 

[Marcelo Branco]

I figured it out....I think! For some reason the less than command will not work if the cells are a formula but if I paste values it works....

Doesn't matter if column F contain formulas. SUMIF works with formulas or not.

M.