SUMIFS formla not working

[drom]

Hi and thanks in advance!

I have to tables in 2 shett
in both tables i have named ranges like

• Iin table2, located in activesheet:
  • rcTb2_Amount
  • rcTb2_Date
• In Table1, located in other Sheet
  • rcTb1_Date
  • rcTb1_Amount

Now I would like to sum in a Column located in the activesheet rcTb2_Amount using SUMIFS and /or ??????
Where the formula need ot check :

• rcTb2_Date <> ""
• rcTb2_Date >= DATE ( year rcTb2_Date),1,1)
• rcTb2_Date <= DATE ( year rcTb2_Date),12, 31))

ANY IDEA

I was Trying to use:

• =SUMIFS(rcTb2_Amount;rcTb2_Date;"<>";rcTb2_Date;">=" & DATE(YEAR(rcTb1_Date);1;1);rcTb2_Date;"<=" & DATE(YEAR(rcTb1_Date);12;31))

In my PC I use ; stead of , in my formulas but I do not get the desired REsult

So I am Using:

• =SUMIFS(rcTb2_Amount,rcTb2_Date,"<>",rcTb2_Date,">=" & DATE(YEAR(rcTb1_Date),1,1),rcTb2_Date,"<=" & DATE(YEAR(rcTb1_Date),12,31))

With no good answer

Check the attached Image


Thanks again!!

 

[C Moore]

Did you step through with Evaluate Formula to see if the calculations were working correctly?