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