If you want to count the number of cells that meet the 100 to 20
criteria,
=COUNTIF(A1:G1,"=100")-COUNTIF(A1:G1,"200")

If you want to add the numbers,
=SUMIF(A1:G1,"=100")-SUMIF(A1:G1,"200")

-gitcyphe

--
Message posted from http://www.ExcelForum.com