Subtotalling

%3CLINGO-SUB%20id%3D%22lingo-sub-3347465%22%20slang%3D%22en-US%22%3ESubtotalling%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3347465%22%20slang%3D%22en-US%22%3E%3CP%3EHI%20there%20I%20am%20looking%20for%20a%20solution%20that%20can%20help%20with%20subtotalling.%26nbsp%3B%20We%20get%20a%20dump%20of%20csv%20type%20data%20from%20our%20payroll%20with%20names%2C%20pay%20types%20pays%20etc%20in%20columns%20and%20I%20wanted%20to%20create%20a%20nice%20subtotal%20for%20each%20person%20so%20its%20easy%20for%20the%20payroll%20clerk%20to%20check.%20However%20the%20subtotal%20excel%20function%20only%20gives%20me%20the%20option%20to%20subtotal%20once%20for%20each%20change%20in%20X.%20Ideally%20i%20would%20sort%20by%20person%20and%20subtotal%20by%20each%20pay%20type%20so%20sick%20leave%2C%20normal%20hrs%20etc%20are%20subtotalled%20by%20person.%26nbsp%3B%20But%20I%20wanted%20to%20try%20and%20automate%20the%20initial%20subtotlling%20rather%20than%20going%20though%20each%20person%20and%20creating%20a%20subtotal%20by%20different%20pay%20type%20which%20takes%20a%20while%20for%20100%20staff.%20Any%20cunning%20ideas%3F%20Cheers%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3347465%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

HI there I am looking for a solution that can help with subtotalling.  We get a dump of csv type data from our payroll with names, pay types pays etc in columns and I wanted to create a nice subtotal for each person so its easy for the payroll clerk to check. However the subtotal excel function only gives me the option to subtotal once for each change in X. Ideally i would sort by person and subtotal by each pay type so sick leave, normal hrs etc are subtotalled by person.  But I wanted to try and automate the initial subtotlling rather than going though each person and creating a subtotal by different pay type which takes a while for 100 staff. Any cunning ideas? Cheers 

1 Reply

@Scottyg1999 Have you looked into using a Pivot Table? Employee in the Row field, Pay type in the Column field and Amount in the Value field.