Awesome Bill
New member
...in Excel 2007? Short and simple. There is a column that has within it 4 different designations. They are W - L - OTL - SOL.
All I want to do is have the number of OTL's and SOL's that occur within that column, to be added up in one cell in another part of the worksheet..
So far, all I have accomplished is getting a SUMIFS function to recognize one or the other. But I've hit a wall trying to figure out how to get two types of criteria to get added up from the same column into another single cell.
This is the formula that works: =COUNTIFS(B2:B1507,"Boston",C2:C1507,"OTL")
When I try adding "SOL", I get the usual Excel error message.
Your help would be greatly appreciated.
That formula that works got cut off at the end. It ends with "OTL")
All I want to do is have the number of OTL's and SOL's that occur within that column, to be added up in one cell in another part of the worksheet..
So far, all I have accomplished is getting a SUMIFS function to recognize one or the other. But I've hit a wall trying to figure out how to get two types of criteria to get added up from the same column into another single cell.
This is the formula that works: =COUNTIFS(B2:B1507,"Boston",C2:C1507,"OTL")
When I try adding "SOL", I get the usual Excel error message.
Your help would be greatly appreciated.
That formula that works got cut off at the end. It ends with "OTL")