Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
formula looking for an either/or solution in same column
0 views
Skip to first unread message
J. Hunter
Nov 24, 2009, 11:22:01 PM11/24/09
to
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")
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
Nov 24, 2009, 11:33:58 PM11/24/09
to
One way...
=SUM(COUNTIFS(A2:A10,"ASAE",B2:B10,{"O*","W*"},C2:C10,"<"&DATE(2050,1,1)))
--
Biff
Microsoft Excel MVP
"J. Hunter" <JHu...@discussions.microsoft.com> wrote in message
news:6709FBD3-E530-49D2...@microsoft.com...
0 new messages