In any case, in this piece what is it doing? Is it offset from "C" 1
column? So the sum
function is reading the C range one cell at a time and if there is a value
in the next column it sums it? Please let me know if I am correct.
TIA,

set streams_needed = Intersect(range("H12:h64000"), ActiveSheet.UsedRange)


For each C in Streams_needed
DCT= Application.worksheetfunction.sumif(streams_needed .offset(0,1),
c.offset(0,1) value, streams_needed)

If c.formula like "=sumif*" then
if C.Value 40 then
c.font.bold = true
c.font.colorindex = 3

end if
end if
Next C