Help with sumifs formula between dates

[chichaspowa]

I am trying to add a column diverse conditions but getting an error when i try set the formula between 2 dates.

I placed the dates on 2 diferent cells on my sheet.

This is the formula, can someone point out if i done something wrong?

=SUMIFS('Plano Geral'!O:O;'Plano Geral'!K:K;A5;'Plano Geral'!M:M;B3;'Plano Geral'!L:L;">='fornecedores na contabilidade'!B4";'Plano Geral'!L:L;"<='fornecedores na contabilidade'!C4")</pre>

Thanks</pre>

 

[Weazel]

maybe a little modification.....?

=SUMIFS('Plano Geral'!O:O;'Plano Geral'!K:K;A5;'Plano Geral'!M:M;B3;'Plano Geral'!L:L;">="&'fornecedores na contabilidade'!B4;'Plano Geral'!L:L;"<="&'fornecedores na contabilidade'!C4)

 

[chichaspowa]

Thanks Weazel,

I managed to figure it out by putting the >= sign on the actual cell. That seemed to help.

Sometimes i cant remember the simplest of things...

Thanks for your help

 

[Weazel]

well, I'm glad you got it working

 

[FDibbins]

With these type of formulas (sumif/s, countif/s etc) you can reference a cell directly if that is teh exact value you want to use. However, if you need to look for values less that (or greater than) that cell's contents, you need to wrap the < in "", and combine that with the cell ref using &. Something like...

=SUMIFS('Plano Geral'!O:O;'Plano Geral'!K:K;A5;'Plano Geral'!M:M;B3;'Plano Geral'!L:L;">="&'fornecedores na contabilidade'!B4";'Plano Geral'!L:L;"<="&'fornecedores na contabilidade'!C4")

See the bolded part