How to SUMIF between two dates?

kai.taylor wrote:
Have I got the syntax wrong?

=SUMIFS(Transactions::Amount,Date,(Date>=B3)&(Date<=C3))
</div>

Yes. And the function, I think.
The ampersand is a concatenation operator—it joins two values into a text string. You're looking for the AND(testA,testB...) function which makes several tests and returns "TRUE" only if all the tests return "TRUE".

SUMIFS() is used when any of several different conditions, and includes the amount in the SUM if ANY of the conditions is TRUE.

You want SUMIF(). But SUMIF() will also give an error unless you put the condition results into a separate column. It might be easier to do this:

I've put the dates into column E and amounts into column F, rows 3:18 in the example.

The following formula goes in G3, and is filled down to G18

=IF(AND(E>=$B$3,E<=$C$3),F3,0)

Then use this formula where you want to report the SUM

=SUM(G3:G18)

Regards,
Barry

Barry wrote:
SUMIFS() is used when any of several different conditions, and includes the amount in the SUM if ANY of the conditions is TRUE.

Badunit wrote:
From the Functions Browser: "If all of the conditions are met, the corresponding cell or value in sum-values is included in the sum.".

SUMIFS will include values where ALL of the conditions are met.