Thread: Formatting a SUM arguement
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default Formatting a SUM arguement
One way:

= -SUM(-I4, J4:P4)

In article ,
lawrencae wrote:

How to subtract a range, j4 through p4, from i4.
Reply With QuoteReply With Quote