Subtotal without subtotalling?

[lilelvis2000]

Actually I'm the Managing Director 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 )

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.

[LisaContractorUmbrella]

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

No I bloody didn't - I'll have a word with him about that!

[LisaContractorUmbrella]

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.

Is that him standing behind you?

[BoredBloke]

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

[lilelvis2000]

Is that him standing behind you?

Luckily for me, I work from home!