Expression for sum (if contains text)

[yvonne-c]

Hi 

Please can you help me with an expression for the following table.

I want to calculate the cost per "JobID" but only include "JobID" that contain code "VR" ( so the total for job IDs 42067, 42074, 42081)

Many thanks

JobID	Code	Price	Job Cost
42066	CPMT1	19.2
42066	V1	21	40.2
42067	BOVT	230.4
42067	VR	15	245.4
42069	CPMT1	19.2
42069	V1	21	40.2
42074	TIM	211.2
42074	SYRI01	0.25
42074	VR	15
42074	CDA	172.8
42074	OPMAT2	25
42074	SYRI01	0.25
42074	SYRI02	1.1	425.6
42081	TIM	201.6
42081	VR	15	216.6

[Anonymous]

PFB-

LOAD CodArt,

     max(Date(FromDate)) as FromDate,

     min(Date(ToDate) ) as ToDate,

     Price

FROM

(ooxml, embedded labels, table is Hoja1)

Group By CodArt , Price;