You would be better off if you fixed the #N/A like
=IF(ISNA(formula),"",formula)
regardless in what column do they (N/A) appear? If they are in one
particular column you could just use
the IF for that particular column, otherwise you could use something like
=SUM((IF(ISNUMBER($A2:$A37),$A2:$A37847300000))*( IF(ISNUMBER($A2:$A37),$A2:
$A37<847399999))*(IF(ISNUMBER($G2:$G37),$G2:$G370 ))*($D2:$D37))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Josh O." wrote in message
...
I am using the following formula:
=SUMPRODUCT(($A2:$A3702847300000)*($A2:$A3702<847 399999)*($G2:$G37020)*($G
2:$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?
|