I have a huge amount of data in a spreadsheet which has 5 workbooks all linked to each other - I need to subtotal a column according to when a reference changes in another column, in two workbooks, without using subtotal (have tried it and Excel falls over). I have a feeling that a simple IF/SUM function should work but I cannot work it out and now I have a headache - can anyone help
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Subtotal without subtotalling?
Collapse
X
-
Subtotal without subtotalling?
-
Originally posted by LisaContractorUmbrella View PostI have a huge amount of data in a spreadsheet which has 5 workbooks all linked to each other - I need to subtotal a column according to when a reference changes in another column, in two workbooks, without using subtotal (have tried it and Excel falls over). I have a feeling that a simple IF/SUM function should work but I cannot work it out and now I have a headache - can anyone help -
Originally posted by woohoo View PostOriginally posted by Stevie Wonder BoyI can't see any way to do it can you please advise?
I want my account deleted and all of my information removed, I want to invoke my right to be forgotten.Comment
-
What if you copied the spreadsheet values (not forumulas) to another sheet and then did a SUBTOTAL?McCoy: "Medical men are trained in logic."
Spock: "Trained? Judging from you, I would have guessed it was trial and error."Comment
-
I think you need to use the SUMIF formula to hold the result of the sum of certain cells that match against a particular contents of a cell.
Google it...This default font is sooooooooooooo boring and so are short usernamesComment
-
Comment
-
Originally posted by MPwannadecentincome View PostI think you need to use the SUMIF formula to hold the result of the sum of certain cells that match against a particular contents of a cell.
Google it...Comment
-
Originally posted by LisaContractorUmbrella View Postnever mind will take my paracetamol and plough onComment
-
If it's a one-off and you suspect it's just excel crashing, I'd try doing the same
on Libreoffice or openoffice to see if they work any better.Comment
-
Originally posted by LisaContractorUmbrella View PostI have a huge amount of data in a spreadsheet which has 5 workbooks all linked to each other - I need to subtotal a column according to when a reference changes in another column, in two workbooks, without using subtotal (have tried it and Excel falls over). I have a feeling that a simple IF/SUM function should work but I cannot work it out and now I have a headache - can anyone help
Can you provide a sample spreadsheet of this (without any real data of course)?
Alternatively, get the formula working on a smaller amount of data then see if it crashes on the main lot?
Martin
Contratax LtdComment
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Comment