I am using the following formula:
=SUMPRODUCT(($A2:$A3702847300000)*($A2:$A3702<847 399999)*($G2:$G37020)*($G2:$G3702<31),$D2:$D3702)

Because the cells in the columns use a formula that sometimes returns a #N/A
result, the result of the above formula is always #N/A. Is there a way to
alter the formula so that is only adds the numbers and returns the sum of the
D column for all the cells that meet the enclosed criteria?