Need to Expand Current Formula

[radiob]

=IF([TimeSheets.xlsx]Tim!B12="_r2500",(SUM('[TimeSheets.xlsx]1st:Last'!$E$23)),"0.0")

This works as expected; however, I need to expand the "Tim" worksheet to include 1st:Last. (When I attempt this, I receive a #REF error.) I don't understand why 1st:Last works in the SUM, but not in the IF statement.

I also need to expand "B12" to include whether the value "_r2500" appears anywhere in column B. (When I attempt this, I also receive a #REF error.) In other words, I need to SUM all instances of "_r2500" to this cell. I have tried "$B:$B" as well as other iterations, but break the formula.

To further complicate matters, if my IF formula proves false, I need the entire row in the resulting invoice to be deleted. "0.0" could obviously be anything that would help toward that end.

 

[radiob]

Update: I realized that I was attempting too much in a single formula. I've now solved and completed the first two steps above. Still seeking a response on the final point, please: dynamically displaying or not displaying a line on the resulting invoice, based on the sum result. Thank you!

 

[Sinon]

You can delete a row with a macro. However, you can also blank it out if you use "" instead of "0.0" in your formula. The cell will look blank.