### Symptom

Why do formulas similar to:

"=SUMIF(Sect1!$C:$C,B27,Sect1!$I:$I)"

not work in Xcelsius?

### Resolution

Looking at the formula, notice that the range selection (Sect1!C:$C) is the entire column. In any Excel function where there is a range selection, the range must be specified.

For example:

$C$4:$C$22

### Keywords

Xcelsius , 7092203 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

### Product

SAP BusinessObjects Dashboards 3.0 ; SAP BusinessObjects Dashboards 3.5 ; SAP BusinessObjects Dashboards 4.5 ; SAP BusinessObjects Dashboards software 4.0