sumproduct and N/A dates

  • Thread starter Thread starter fluffymitten
  • Start date Start date
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
 
Try this array formula

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