View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

You'll get an error in V29 if J29, I29, or M29 contains a text
value. You can have a formula ignore text values by using the SUM
function. E.g.,

=SUM(J29,I29,M29)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"Pat" wrote in message
...
With M29 containing a condition V29 returns a #VALUE! error.

V29 =J29+I29+M29

M29 =IF(J29="","",J29)

What change do I need to make to the formula in V29 so an error
does not
appear.

Thanks
Pat