SUM by unique reference
This is an option and I thank you, but I want to try and show everything on
one spreadsheet as their will then be extra analysis.
"Gary''s Student" wrote:
Consider using a pivot table. If our data is, for example:
reference
1956
1956
1956
1956
1956
1956
1956
1956
3466
3466
3466
3466
3466
2134
2134
6789
then a simple pivot table would give:
Count of reference
reference Total
1956 8
2134 2
3466 5
6789 1
Grand Total 16
--
Gary''s Student - gsnu200732
"WendyUK" wrote:
Hi, I am trying to bring out multiple totals based on a Reference Number with
an unknown number of lines.
i.e ref 1956 could have 8 lines and ref 3466 could have 5 lines and I want
to show a total for each unique reference - can anyone help me?
|