sumproduct and N/A dates

F

fluffymitten

The following formula produces #N/A because some of the formulae in AB
produce #N/A. If I overwrite or remove the formulae producing the error, it
calculates correctly but I then lose information. How can I rewrite this to
essentially ignore errors - I would put in a NOT(ISERROR(blah blah)) but
can't see where to fit it in.

=SUMPRODUCT((A4:A278=1)*(AB4:AB278<TODAY()))

Many thanks for your help
Louise
 
B

Bob Phillips

Try this array formula

=SUM(IF(ISNUMBER(AB4:AB278),(A4:A278=1)*(AB4:AB278<TODAY())))
 
Top