Calculate Values in a row based on value of first column

Hello,

I hope my question is an easy one.

I have a table from A:9 to H:24. Column A contains drown down menus with various choices. Columns "B" thru "H" have the letter "L" or the letter "T" in them. I want a formula to calculate the number of cells that contain the letter "L" in a row when column A reads "NLE".

For example...

If A:12 = "NLE" then I want to calculate the number of cells from B:12 to H:12 that equal "L".
If A:23 = "NLE" then I want to calculate the number of cells from B:23 to H:23 that equal "L".

I want my formula to produce a sum of the "L"s in these rows but only if Column A in that row contains the value "NLE" from the drowndown. Is this possible with a simple formula? Or do I have to use VBA? Any help would be greatly appreciated! Thanks!

Thank you FDibbins. What you are suggesting is how the formula is currently written, however, I am going to be adding four more tables and would like to repeat the formula for all four tables. I'm hoping to find a way to simplify the formula so there aren't 50 different additions in the same formula. I was hoping to find a simple formula for each table and then add the sums of each table. I can manage the second part but I wasn't sure how to simplify the formula or the single table or if this needed VBA.