sumif count trips

[makinmomb]

I have this on column B

DATE

1-Sep-18

1-Sep-18

1-Sep-18

1-Sep-18

1-Sep-18

1-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

2-Sep-18

<colgroup><col></colgroup><tbody>
</tbody>

I have this on column F

DESTINATION

KASUMBALESA

LUBUMBASHI

LUBUMBASHI

LUBUMBASHI

LUBUMBASHI

LUBUMBASHI

LUBUMBASHI

LUBUMBASHI

GOMA

LUBUMBASHI

LUSAKA

LUBUMBASHI

GOMA

KOLOWEZI I have this on v2 onwards DATE GOM KAS KIT LUB LUS NDO 1-Sep-18 1 5 2-Sep-18 2 5 1 <colgroup><col><col span="6"></colgroup><tbody> </tbody>

<colgroup><col></colgroup><tbody>
</tbody>

I want formula on w2 rightwards drag down to do the
count automatically , I have shortened the name of the
locations , but assume the names are exactly in long length
so that the sumif catches the count of trips

Moto of the formula count trip to destination date wise without
computing them manually

 

[Scott T]

Book1
	V	W	X	Y	Z	AA	AB
1	DATE	GOMA	KASUMBALESA	KIT	LUBUMBASHI	LUSAKA	NDO
2	1-Sep-18	0	1	0	5	0	0
3	2-Sep-18	2	0	0	4	1	0
Sheet1

Cell Formulas
Range	Formula
W2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,W$1)
X2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,X$1)
Y2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,Y$1)
Z2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,Z$1)
AA2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,AA$1)
AB2	=COUNTIFS($B$2:$B$15,$V2,$F$2:$F$15,AB$1)

copy down

 

[makinmomb]

works with this on w2 drag right but does not work on copy down

=COUNTIFS($B$2:$B$1000,$V3,$F$2:$F$1000,W$2)

 

[makinmomb]

I want the drag down to work

 

[Aladin Akyurek]

I want the drag down to work

In W2 enter, copy across, and down:

=COUNTIFS($A$2:$A$15,$V2,$B$2:$B$15,W$1&"*")

 

[thehay95]

very simple