View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jag Jag is offline
external usenet poster
 
Posts: 16
Default Summing across columns while skipping some columns

Does anyone know of an easy way to accomplish this?

In the example below, I do not wish to add the values in columns G18 and J18.
=SUMIF(F18:L18,"<#N/A",F18:L18)

Thanks in advance for any replies.
Joe