Simple Formular
 

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.

Simple Formular
 

Hi,


It's an array formula.

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

You can learn more anout arrays on the attached link.

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

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=573256

Simple Formular
 

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.