In my spreadsheet I have an input table. I want to count the number of trucks
leaving each city on a certain day. Then in addition, ideally for one city I
want to know how many loads are heavier that 15MT. The other cities don't
have heavy loads.

Can anyone please help with a formula to use. I think it needs to be an
array formula.

Input Table Output Table
<15 15
Date City Weight Date Omsk Tobolsk Tobolsk
11-Feb Omsk 12 11-Feb 0 0 0
12-Feb Omsk 3 12-Feb 2 1
12-Feb Tobolsk 5 13-Feb 2 0 0
13-Feb Omsk 12 14-Feb 2 1 1
13-Feb Omsk 12 15-Feb 0 0 1
14-Feb Omsk 4 16-Feb 1 1 1
14-Feb Omsk 1 17-Feb 1 0 0
14-Feb Tobolsk 25 18-Feb 0 0 0
14-Feb Tobolsk 12
15-Feb Tobolsk 20
16-Feb Omsk 3
16-Feb Tobolsk 5
16-Feb Tobolsk 24
17-Feb Omsk 5