How to sum values between two dates?

Question

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

My idea was to make a formula like this:
=SUMIFS((E4;G4),(F4;H4),">="&DATE(1/1/14),(F4;H4),"<="&DATE(1,1,15))

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

Answer 1

To use SumIf you need a single column with data to be summed up, and a second column with something you can check (a boolean for example).

I extract every 2nd cell for column 1 :

={
filter(transpose(C4:AG4); mod(transpose(ArrayFormula(COLUMN((C4:AG4))+1));2)=0);
filter(transpose(C5:AG5); mod(transpose(ArrayFormula(COLUMN((C5:AG5))+1));2)=0);
filter(transpose(C6:AG6); mod(transpose(ArrayFormula(COLUMN((C6:AG6))+1));2)=0)
}

And for column 2, the date :

={
filter(transpose(C4:AG4); mod(transpose(ArrayFormula(COLUMN((C4:AG4))));2)=0);
filter(transpose(C5:AG5); mod(transpose(ArrayFormula(COLUMN((C5:AG5))));2)=0);
filter(transpose(C6:AG6); mod(transpose(ArrayFormula(COLUMN((C6:AG6))));2)=0)
}

Now I just need to check every date in column 2 with something like this : =AND(YEAR(L22)>=2014;YEAR(L22)<2015)

That's where I saw that there are problems with your date. Some of them are string : =ISDATE() return a falsy.

Please correct the date input. Anyway, here's the final sumif :

=sumif(M22:M63;true;K22:K63)

M22:M63 is column 1
True is our criteria (>=2014 AND <2015)
K22:K63 is column 2 after boolean check