sumif of non-adjacent cells

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Need Help with a VBA subroutine 0
SUMIF with non-adjancent cells 3
summing adjacent data in a worksheet 3
SUMIF with criteria "<>" & "=" 4
Use TODAY() function as the criteria in a SUMIF formula 1
SumIf equation question 6
Visio: copy text of a master shape to User-define Cells (Variable) 0

Top