How to get sum of number of events for the client Delta

Louis.Smith · 08/22/23

Formula I tried:

=SUM(Client:Client = "Delta", Events:Events)

Then I also want to be able to count the number of events per fleet:

"B757/767"

JamesB · 08/22/23

@Louis.Smith You will need a SUMIFS statement to get the total number of events.

=SUMIFS(Events:Events,Client:Client,"Delta")

To get the number of events by fleet

=SUMIFS(Events:Events,Fleet:Fleet,"B757/767")

1 Step further to get B757/767 by client would be:

=SUMIFS(Events:Events,Fleet:Fleet,"B757/767,Client:Client,"Delta")

Louis.Smith · 08/22/23

How would I calculate avg, I tried the below but it didn't give me the correct value:

=AVG(Events:Events, Fleet:Fleet, "M88", Client:Client, "Usa Jet")

Paul Newcome · 08/23/23

@Louis.Smith You will need an AVG/COLLECT combo. The syntax will be the same as your SUMIFS but you would use AVG(COLLECT(..........)) instead.

Answers