hi guys

i need a formula that will add the sum from c7 to c20 if the text "jp" appears in e:7 to e20

could you please help me out?

thanks
savvio