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