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