• 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?

Actually I'm the Managing Director :tongue I also love spreadsheets which is why I still get involved with this stuff (probably much to the annoyance of the team who'd far rather I was off playing golf or something :wink)

Kinda like my client who just loves to f**k things up. God bless him. For without him I would not earn the piddly sums that I do.
 
I was going to say manager and owner but then remembered that its part of your brother's SJD group.

Did you get your company horse in the end?

Yep Simon's the big cheese - I'm the cheese niblet :happy

No I bloody didn't - I'll have a word with him about that!
 
Pivot it or if you don't like pivots then do this. Get all the data into a consistent format and use SUMIFS (not Sumif). That way you can use multiple criteria. Then take your ID column and copy it to another sheet. Use remove duplicates to generate a single list of unique values. Use SumIfS to summarise against this.

I could look at it if you want
 

Advertisers

Back
Top