Do I need to fix it or are there similar formulas?

Question

Google

Here are two screenshots: prntscr.com/bin23c - this is the formula itself, I'll attach more code here. Here's the page where the formula should work: prntscr.com/bin2ti
If I substitute data into the range 'Operations'!$A:$G , then the table = 0 anyway What's wrong with the current formula?

=iferror(QUERY('Операции'!$A:$G;"select SUM(E) where A >= date '2016-04-01' and A <= date '2016-04-31' and C = """&$A2&""" Label SUM(E) ''";);0)

What are the equivalents of this formula?