Forum Discussion
Totalling values in column X for all rows with identical values in column Y
I want my formula in F10 to return the sum of the values in column D (hours worked) by each volunteer (identical names in column A). I get a circular reference error. Can anyone show me where I'm g...
To identify the cell where the Circular Reference occurred:
1. Click on Formulas tab
2. In the Formula Auditing group,click on the dropdown of Error Checking
3. Click on Circular Reference and the cell that contains circular reference.
4. Then adjust the cell reference as appropriate
1. Click on Formulas tab
2. In the Formula Auditing group,click on the dropdown of Error Checking
3. Click on Circular Reference and the cell that contains circular reference.
4. Then adjust the cell reference as appropriate