sumif of non-adjacent cells

  • Thread starter Thread starter YHP
  • Start date Start date
Y

YHP

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)
 
Back
Top