=SUM(IF((YEAR(P4)=YEAR(LS510!$A$1:$A$100))+(MONTH(P4)=MONTH(LS510!$A$1:$A$100)),LS510!$E$1:E$17)). I am trying to create an array formula, my attempt above is to look at the date (February 2014) in one worksheet and calculate the total from another, as per the table below. I have formatted the dates in both worksheets to be the same. My formula above is calculating the total amount in column E where as it should be £6204.65 and wont allow me to control/alt/enter? Thank you in advance any help will be greatly appreciated.[TABLE="width: 397"]
<tbody>[TR]
[TD][/TD]
[TD]B
[/TD]
[TD] C
[/TD]
[TD] D
[/TD]
[TD] E
[/TD]
[/TR]
[TR]
[TD]01/02/2014
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 1,862.74
[/TD]
[/TR]
[TR]
[TD]08/02/2014
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,273.69
[/TD]
[/TR]
[TR]
[TD]22/02/2014
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,068.22
[/TD]
[/TR]
[TR]
[TD]01/03/2014
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,273.69
[/TD]
[/TR]
[TR]
[TD]08/03/2014
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD] 1,945.77
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/03/2014
[/TD]
[TD]6
[/TD]
[TD][/TD]
[TD] 2,472.47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22/03/2014
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD] 2,567.28
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29/03/2014
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD] 2,209.12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/04/2014
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD] 796.61
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00
[/TD]
[TD]9,991.25
[/TD]
[TD]8,478.34
[/TD]
[/TR]
</tbody>[/TABLE]
<tbody>[TR]
[TD][/TD]
[TD]B
[/TD]
[TD] C
[/TD]
[TD] D
[/TD]
[TD] E
[/TD]
[/TR]
[TR]
[TD]01/02/2014
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 1,862.74
[/TD]
[/TR]
[TR]
[TD]08/02/2014
[/TD]
[TD]2
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,273.69
[/TD]
[/TR]
[TR]
[TD]22/02/2014
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,068.22
[/TD]
[/TR]
[TR]
[TD]01/03/2014
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD] 2,273.69
[/TD]
[/TR]
[TR]
[TD]08/03/2014
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD] 1,945.77
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15/03/2014
[/TD]
[TD]6
[/TD]
[TD][/TD]
[TD] 2,472.47
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]22/03/2014
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD] 2,567.28
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]29/03/2014
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD] 2,209.12
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]05/04/2014
[/TD]
[TD]9
[/TD]
[TD][/TD]
[TD] 796.61
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]0.00
[/TD]
[TD]9,991.25
[/TD]
[TD]8,478.34
[/TD]
[/TR]
</tbody>[/TABLE]