sumifs with multiple criteria and date range year

BACKGROUND
In cell F5 I use the following formula to summarize values based on two criteria:
=SUMIFS(Input!$F:$F,Input!$B:$B,$D5,
Input!$G:$G,$D$2,
Input!$A:$A,">="&F$2,Input!$A:$A,"<"&G$2)

EXPLANATION
Input!$F:$F is a column with values
Input!$B:$B is a column with range1
D5 is criteria1 (that needs to match with criteria in the list Input!$B:$B with range1)
Input!$G:$G is a column with range2
D2 is criteria2 (that needs to match with criteria in the list Input!$G:$G with range2)
Input!$A:$A is a column with dates (format: dd/mm/yyyy)
F$2 and G$2 are (1st of the month) dates
The formula works like a charm: it summarizes for the month, the values, matching the two criteria.

REQUIREMENT
In cell B5 I want to do the same (as in cell F5) but not for a month but for a year: summarize the values for a year, matching the two criteria.

ISSUE
The layout of the sheet doesn’t allow me to use the ">="&F$2 and "<"&R$2 elements. I would like to summarizes the values, matching the two criteria, for a year, isolating the year format in the date column (Input!$A:$A). The formula appears to have an error:

=SUMIFS(Input!$F:$F,Input!$B:$B,$D5,
Input!$G:$G,$D$2,
"="YEAR(Input!$A:$A))

Can anyone help me?

The layout of the sheet doesn’t allow me to use the ">="&F$2 and "<"&R$2 elements

Why not?
Why can't R2 simply be a date that is 1 year from F2 ?

Try
=SUMIFS(Input!$F:$F,Input!$B:$B,$D5,
Input!$G:$G,$D$2,
Input!$A:$A,">="&F$2,Input!$A:$A,"<"&EDATE(F$2,12))

Good morning Jonmo1; Thank you for your fast response. And it works, thanks!

Yet, I was hoping for a solution that would accommodate my extended requirement. Whilst
Column F-Q are the monthly values of 2016 and
Column B the annual 2016 total,
Column A and column C are the annual totals for 2015 and 2017 respectively.

Whilst your formula works for cell B5, I don't have an idea how I can use your solution for A5 and C6. Do you have a suggestion?

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Thank you JohnTopley (and AliGW) for your guidance.

Please find attached the sheet. I hope this clarifies my inquiry. Thank you in advance for the help,

Gijs

Hi Siva, thank you for helping me. To your question, if I were to do it manually, I would:

In sheet ‘Per month’ in cell B5
sum the values in sheet ‘Input’ column F, based on the range1 YEAR (column A) and the range2 (column G),
matching in sheet ‘Per month’ criteria1 (cell B2) and criteria2 (cell D2)

In sheet ‘Per month’ in cell F5
sum the values in sheet ‘Input’ column F, based on the range1 MONTH (column A) and the range2 (column G),
matching in sheet ‘Per month’ criteria1 (cell F2) and criteria2 (cell D2)

Thank you shukla.ankur281190.

1) I assume you mean I'm to put the formula in B3 (not A3)?
2) I also assume I need to insert a column (D) and put 2018 in D2 to make the formula work for C3?

Originally Posted by shukla.ankur281190

Try

A3=SUMIFS(Input!$F:$F,Input!$A:$A,">="&DATE(B$2,1,1),Input!$A:$A,"<="&DATE(B$2,12,31),Input!$G:$G,$D$2,Input!$B:$B,$D3)

copy across C column

I understand.

To my other question: I assume I insert the formula in B3 (NOT A3 as you wrote earlier), before copying it across and down?