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

[PFS12]

[TABLE="width: 959"]
<tbody>[TR]
[TD]R04973[/TD]
[TD]LEICA 2DEXC KIT & PA[/TD]
[TD]20180219[/TD]
[TD]$0.00[/TD]
[TD]$0.01[/TD]
[TD]MI[/TD]
[TD]$0.01[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]R05054[/TD]
[TD]MISC RE-RENTAL UNIT[/TD]
[TD]20180416[/TD]
[TD]$0.00[/TD]
[TD]$0.01[/TD]
[TD]MA[/TD]
[TD]$0.05[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]R05065[/TD]
[TD]MISC RE-RENTAL UNIT[/TD]
[TD]20180419[/TD]
[TD]$0.00[/TD]
[TD]$0.01[/TD]
[TD]MA[/TD]
[TD]$0.01[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]


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.