# {Sum(if(... )} Applied To Whole Columns

Jun 23, 2008I cannot acheive to have a {Sum(if(...)} formula applied to whole columns. See below.

The following formula return a numeric value. So it works.

{=SUM(IF(Query!$L1:$L65535=TEXT($A37,"@"),Query!$AM1:$AM65535,))}

(confirmed with Ctrl+Shift+Enter)

The following formula returns #NUM. So it fails.

{=SUM(IF(Query!L:L=TEXT($A37,"@"),Query!AM:AM,))}

(confirmed with Ctrl+Shift+Enter)

how to use {Sum(if(... )} to whole columns?