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!