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...
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.