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 going wrong? Thanks to all!
3 Replies
As variant, if data sorted by names and show totals against last record with each name
=IF( A2=A3,"",SUMIF(A:A,A2,D:D))or simply pivot the range
- 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 Are you trying to achieve something like:
F2 = SUMIFS($D$2:$D$13,$A$2:$A$13,A2)Copy that formula down.
Otherwise you could do something like:
Where
I2 = SUMIFS($D$2:$D$13,$A$2:$A$13,H2)Copy that formula down.
