Google sheets: how to sum values between two dates?

by Jacopo Salvatore   Last Updated September 11, 2019 23:03 PM

I have a table made up of numbers followed by dates like the one below only with more columns (link below).

How would I sum only the values that occur in one specific year?
For example, in this case, how would I sum the the values that occur only in 2014?

    A              B             C           D             E           F  
----------------------------------------------------------------------
$200.000,00    12/9/11     $100.000,00   4/4/12       $50.000,00    6/12/12
$25.000,00     4/15/14     $32.500,00    11/26/14     $32.500,00    4/10/15
$50.000,00     9/29/17     $50.000,00    9/1/18       $50.000,00    5/11/18

I created a sample spreadsheet in Google sheets with my failed attempt

link:https://docs.google.com/spreadsheets/d/1NCzOmpJpnorB5diPCYewjU9c4KS_quMU9fUzyfGiJ8s/edit?usp=sharing



Related Questions






Import range from 3 sheets/tabs into 4th

Updated February 06, 2019 12:03 PM