Excel for dummies (me)

Zico

Zico

Zico

Soldato
Joined
15 Jan 2003
Posts
4,948
Location
South East
It's been a very long time since I have used Excel and I've forgotten a lot of the formulas that should make things easier.

I'm trying to get the totals for several organisations, that are on multiple worksheets, with each worksheet containing a mix of organisations but with the same layout.

For example, all worksheets will have column A as Organisation, but the list will be in a different order.
So Org A, B, C in one worksheet but maybe Org A, C, D and E in the next.

To further blow my brain, I also want to try and sum the value of other columns based on the organisation found in column A.

I've been stuck between COUNTIFS, SUMPRODUCT and SUMIFS but just keep getting muddled.
 
Evening @Th0nt , sorry I completely forgot I had posted here. I was so busy with trying to finish off work and other things last week I just forgot about this post.

I should have explained a little better that I'm getting 5 or 6 different Excel CVS outputs from a main database and was trying to merge them all (something I now realise can't quite be with Power Query).

As much as I would like the help in getting to grips with things, I feel like it's cheating to just get someone to point out what to do. I'm going to make some time to go over things in the next few weeks as I've got a friend who's also doing something similar with the data using Power Bi (something that I'm going to need to get to grips with as well).

If you have any good guides or links to any that cover Power Query then that would be great.
 
You must log in or register to reply here.
Back
Top Bottom