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

SUMIF with non-adjancent cells 3
summing adjacent data in a worksheet 3
SUMIF formula with non contiguous cells 2
XIRR non adjacent cells 2
SUMIF with criteria "<>" & "=" 4
How to use SUMIF function with non-adjacent cells 5
SUMIF on a Calculated Field 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4

Top