View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default sumif of non-adjacent cells

What are the actual range addresses of Term2u and Term1u?

--
Biff
Microsoft Excel MVP


"YHP" wrote in message
...
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)