So I've already found this question answered several times around here but for some reason, despite essentially copy and pasting the answers it still doesn't work for me.

I'm trying to add everything in a column (Americas!B:B) if the values in a date column are between two dates, so far I've tried this:


The sum would be happening on a different sheet (not the Americas sheet), and B13 and B14 are the start and end dates, respectively.


1 Answer 1


Your formula is valid. Try perhaps:

=SUMIFS(Americas!B1:B; Americas!A1:A; ">=" & $B$13; 
                       Americas!A1:A; "<=" & $B$14)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.