# Google Spreadsheets Equation

=SUM((INDIRECT("SA_Report_Data!T"&B13):(INDIRECT("SA_Report_Data!T"&C13))))+SUM((INDIRECT("SA_Report_Data!X"&B13):(INDIRECT("SA_Report_Data!X"&C13)))))/SUM((INDIRECT("SA_Report_Data!AM"&B13):(INDIRECT("SA_Report_Data!AM"&C13)))

This does not seem to work for me...

(sum of range + sum of range)/(sum of range)
LVL 1
Asked:
###### Who is Participating?

Commented:
Brackets in wrong place ?
Check to see if either of the following help
``````=(SUM(INDIRECT("SA_Report_Data!T"&B13):INDIRECT("SA_Report_Data!T"&C13))+SUM(INDIRECT("SA_Report_Data!X"&B13):INDIRECT("SA_Report_Data!X"&C13)))/(SUM(INDIRECT("SA_Report_Data!AM"&B13):INDIRECT("SA_Report_Data!AM"&C13)))
``````
..OR..
``````=(SUM((INDIRECT("SA_Report_Data!T"&B13)):(INDIRECT("SA_Report_Data!T"&C13)))+SUM((INDIRECT("SA_Report_Data!X"&B13)):(INDIRECT("SA_Report_Data!X"&C13))))/(SUM((INDIRECT("SA_Report_Data!AM"&B13)):(INDIRECT("SA_Report_Data!AM"&C13))))
``````

I'm not familiar with Google spreadsheet app but I made a few assumptions and focused on the placement of brackets in your code.
``````=(SUM(INDIRECT("SA_Report_Data!T"&B13):INDIRECT("SA_Report_Data!T"&C13))+SUM(INDIRECT("SA_Report_Data!X"&B13):INDIRECT("SA_Report_Data!X"&C13)))/(SUM(INDIRECT("SA_Report_Data!AM"&B13):INDIRECT("SA_Report_Data!AM"&C13)))
``````
``````=(SUM((INDIRECT("SA_Report_Data!T"&B13)):(INDIRECT("SA_Report_Data!T"&C13)))+SUM((INDIRECT("SA_Report_Data!X"&B13)):(INDIRECT("SA_Report_Data!X"&C13))))/(SUM((INDIRECT("SA_Report_Data!AM"&B13)):(INDIRECT("SA_Report_Data!AM"&C13))))
``````
0

Commented:
Or maybe

``````=(SUM(INDIRECT("SA_Report_Data!T"&B13):INDIRECT("SA_Report_Data!T"&C13))+SUM(INDIRECT("SA_Report_Data!X"&B13):INDIRECT("SA_Report_Data!X"&C13)))/(SUM(INDIRECT("SA_Report_Data!AM"&B13):INDIRECT("SA_Report_Data!AM"&C13)))
``````

seems to work in the attached file

Formula.xls

Regards,
Curt
0

Author Commented:
Both solutions helped with the issue
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

## Already a member? Login.

All Courses

From novice to tech pro — start learning today.