ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   formula looking for an either/or solution in same column (https://www.excelbanter.com/excel-worksheet-functions/249327-formula-looking-either-solution-same-column.html)

J. Hunter

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")


T. Valko

formula looking for an either/or solution in same column
 
One way...

=SUM(COUNTIFS(A2:A10,"ASAE",B2:B10,{"O*","W*"},C2: C10,"<"&DATE(2050,1,1)))

--
Biff
Microsoft Excel MVP


"J. Hunter" wrote in message
...
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")





All times are GMT +1. The time now is 05:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com