Sum in Excel to ignore a text field
Posted on 2011-09-13
I need to sum 5 columns, in each of the columns if the header is blank then the formula inputs "" (here is a copy of one of the columns formulas - =IF($AY$1="","",SUM(AZ5:AZ51)) )
When I try to add up all 5 columns I get a #Value! error.
can you help?