Need to Sum a column if another column contains a Letter followed by numbers

[PFS12]

R04973	LEICA 2DEXC KIT & PA	20180219	$0.00	$0.01	MI	$0.01	1
R05054	MISC RE-RENTAL UNIT	20180416	$0.00	$0.01	MA	$0.05	5
R05065	MISC RE-RENTAL UNIT	20180419	$0.00	$0.01	MA	$0.01	1

<tbody>
</tbody>

The above is a snapshot of a sheet I run, The invoices come in labeled with an R for "rental". the will be mixed in with "P" and "Q" and "W" documents. How can I have a cell search for invoices that contain an R? I used

=SUMIFS(October!$L$19:$L$2004,October!F19:$F$2004,"*"&R&"*") but it keeps telling me the R is wrong. if it fixes it for me it ends up like

=SUMIFS(October!$L$19:$L$2004,October!F19:$F$2004,"*"&"*") and works but I am not sure if it really works, I can't copy and paste it into a different month and make it work again.

The dollar amount I want summed is in column L and the invoices come in in column F.

Thanks in advanced to anyone who can teach me the error of my ways.

 

[KennyGreens]

Hi there, your formula is correct, just instead of "*" & R & "*", make it "*" & "R" & "*". The R part has to be in quotes.

 

[PFS12]

Thank you sir!

 

[jtakw]

Hi,

Actually, all you need is "*R*" rather than "*"&"R"&"*", however, either way will work.