Grabbing data from a column based on another column

[dskills]

Hello all,

I've been working on this for a day or so and can't seem to conceptually understand how to code up a formula.

I've got a sheet with 3 columns:

• Type of meeting - there are only two types: Customer meeting, Executive meeting
• Industry for that meeting - examples would be, say, Retail, or Finance
• Number of people attending the meeting

What I want to do is create a summary table from this data. The summary might look like this:

Customer meetings - Finance: 4
Customer meetings - Retail: 8

Executive meetings - Finance: 2
Executive meetings - Retail: 4

The number at the end is the sum of the Number of people attending the meeting where it is both a Customer Meeting and Finance (as an example).

I can do this easily with a pivot table, but for reasons that are boring, I can't use a pivot table.

I expect the answer is easier than I think and I'm just being a dummy, but if anyone can help I'd much appreciate it!

 

[Z51]

You should be able to use SUMIFS formulas, e.g.

If column A contains meeting types, column B is Industry, column C is attendee count, then:

=SUMIFS(C:C,A:A,"Executive",B:B,"Finance")

 

[dskills]

That works perfectly - thank you so much.