yogi_Compute How Many Pax Each Lecturer Has Form A Table Of Lectures With A Lecturer Being On More Than Once Per Day

                                         Google Spreadsheet   Post  #1675
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun-15-2014
post by Matthias Stasaik: (https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!category-topic/docs/spreadsheets/oRT-Qm42YeQ)
Sum of people that has attended a week of seminars hosted by specific lecturers

Hi Forum,

In the below spreadsheet I'd like to know how many Pax each Person has had on their seminars these 5 days.  I've tried to use VLOOKUP but that only works for days when each lecturer only did 1 seminare.  Lecturers never do more than 2 seminars in a day.  I've experimented with ARRAYFORMULA, SUM and VLOOKUP and failed miserably...  I have a feeling there is an easier solution since this isn't exactly a very strange situation...

I'd like to have a resulting list like this:

Kind regards,

Matthias

-------------------------------------------------------------------------------------------------------------------------------------------