View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
YHP YHP is offline
external usenet poster
 
Posts: 1
Default sumif of non-adjacent cells

How can I sum the non-adjacent cells with SUMIF function?
I used the below function (the areas, Term2u and Term1u, are using
non-adjacent cells); however, I got error (#VALUE!)

=SUMIF(Term2u,"-1",Term1u)