View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Caplin Girl Caplin Girl is offline
external usenet poster
 
Posts: 1
Default Omitting Negative Numbers

Hi there,
I'm wondering if there is a formula that will omit a number from a table
when it is negative. If so, please inform me how to add it to a formula that
looks like this:
=SUM(B90,B109,B149,B168)-B128-B187
Thanks.