| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula looking for an either/or solution in same column
I have a spreadsheet with one column showing pay grade - O3, O4, W2, W3.....
I have a formula which selects anything starting with O, but I need the formula to also look for either O or W and count both of them together. any help? The current formula is: =countifs(I2:I120,"=ASAE",B2:B120,"=O?",L2:L120"<1/1/2050") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return column header as solution to lookup | Excel Worksheet Functions | |||
| formula or vba solution | Excel Worksheet Functions | |||
| Formula Solution | Excel Worksheet Functions | |||
| Need solution to formula problem | Excel Discussion (Misc queries) | |||
| solution: how to sum/add a column pasted from internet | Excel Discussion (Misc queries) | |||
Threaded Mode
