Sheet summary sum function

R Harrington

The column I am attempting to sum is using a cross sheet reference to pull data in from another sheet. When I use a sum formula in the sheet summary field it is returning a no match. I'm assuming the sheet summary fields are limited to actual values but figured I would ask.

Aravind GP

Hi,

Cross sheet references will not impact the sum or sumif formulas that you might want to use. You might get No Match where one or more values in the range that you are trying to sum are non numeric values. You can use Sheet Summary section or a separate metrics sheet to do your sum or sumif calculations as long as all values in the range are numbers.

Aravind GP

Hi,

Cross sheet references will not impact the sum or sumif formulas that you might want to use. You might get No Match where one or more values in the range that you are trying to sum are non numeric values. You can use Sheet Summary section or a separate metrics sheet to do your sum or sumif calculations as long as all values in the range are numbers.

R Harrington

Thank you for the insight and found the issue! Thanks again