how many trip by location ?

[Mak Man Ina]

formula on h2 drag right and down , see expected results of 1st sep

[Mak Man Ina]

Looks like to be some kind of sumif likely

[Sam Capricci]

this looks like it would work...
=SUMPRODUCT(($B$2:$B$33=$G2)*($C$2:$C$33=H$1))
in H2, dragged right and down.

[Mak Man Ina]

It does not plug 2 for Goma on 2nd SEP

[Glenn Kennedy]

Try:

=COUNTIFS($B:$B,$G2,$C:$C,H$1)

[Glenn Kennedy]

or... if you don't want to see all those distracting zeros...


=IFERROR(1/(1/COUNTIFS($B:$B,$G2,$C:$C,H$1)),"")

[Sam Capricci]

It does not plug 2 for Goma on 2nd SEP

it did for me.