Calculating Teaching Period per Instructor

[baileyb103]

Good afternoon,

I am after a formula that will count how many teaching period each instructor will be teaching during a course. As some lessons are over 1 period long I can't just use a simple COUNT formula. Is there a way of creating a formula or array that will do this?

Many thanks in advance.

 

[etaf]

is it a sumif()
are the periods in column G
so is it a SUM
assuming 2 means 2 periods, 1 = 1 period , 3 = 3periods

so by instructor - then a sumif()

=SUMIF($H$4:$H$1000,K4,$G$4:$G$1000)