Jan 17 2020 09:16 AM
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!
Jan 17 2020 09:34 AM - edited Jan 17 2020 09:35 AM
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.
Jan 17 2020 10:03 AM - edited Jan 17 2020 10:04 AM
Jan 17 2020 01:17 PM
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