Simple Formular

[Jay]

Thanks in advance

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

 

[VBA Noob]

Hi,


It's an array formula.

Its check cell ref BY233:BY263 (column 77) is greater than range
D279309

You can learn more anout arrays on the attached link.

http://www.cpearson.com/excel/array.htm

VBA Noo

 

[Toppers]

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