BY is the column (Heading). Columns go from A to IV (256 in all).

The formula is testing for values in column BY, rows 233 to 263 being 0
and if so, sum the "equivalent" values in Column D, rows 279 to 309.

HTH

"Jay" wrote:

Thanks in advance

Question about formula: "=SUM(IF(BY233:BY2630,D279:D309))"
I don't get this formula, especially about BY233:BY263: What is meant by "BY"?
Please, help.