great! that worked as far as getting the SUMPRODUCT formula to bring back a
value. however, i'm still having trouble getting it to only sum specific
cells in that row. it's not returning an error, but it is adding everything
in that row. is there a way to select specific cells to sum together?

Thanks--this is a big help as it is and will be useful in many other
applications.

"JE McGimpsey" wrote:

Unless you want to hardcode each cell, you should trap the errors
instead of leaving them as "expected errors". This is good practice
anyway.

For example, instead of

P10: =N10/O10

where O10 may be zero, use

P10: =if(O10<0,N10/O10,"")


SUM() (and SUMPRODUCT()) will then ignore the null string.


In article ,
Sam wrote:

This is where I'm having trouble. Thanks for all your help!