ExcelBanter - sumif of non-adjacent cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - sumif of non-adjacent cells (https://www.excelbanter.com/excel-worksheet-functions/217380-sumif-non-adjacent-cells.html)

YHP

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)

T. Valko

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)

All times are GMT +1. The time now is 11:57 AM.