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())))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OR in SUMPRODUCT formula 4
Sumproduct, but errors in column 6
Sumproduct gives #value 6
SUMPRODUCT that contains multiple criteria 3
SUMPRODUCT with date range running slow 1
SUMPRODUCT 3
Sumproduct with #N/A in range 7
blank error 0

Top