Thread
:
sumif of non-adjacent cells
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
YHP
external usenet poster
Posts: 1
sumif of non-adjacent cells
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)
Reply With Quote
YHP
View Public Profile
Find all posts by YHP