how many trip by location ?

**Mak Man Ina** · 09-05-2018, 08:16 AM

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

**Mak Man Ina** · 09-05-2018, 08:17 AM

Looks like to be some kind of sumif likely

**Sam Capricci** · 09-05-2018, 08:21 AM

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** · 09-05-2018, 08:34 AM

It does not plug 2 for Goma on 2nd SEP

**Glenn Kennedy** · 09-05-2018, 08:41 AM

Try:

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

**Glenn Kennedy** · 09-05-2018, 08:43 AM

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** · 09-05-2018, 08:46 AM

It does not plug 2 for Goma on 2nd SEP

it did for me.

Re: how many trip by location ?