formula looking for an either/or solution in same column

J

J. Hunter

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

T. Valko

One way...

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countif or other formula needed for multiple data/critera results 3
Need Formulas for counting multiple conditions 4
keeping same-row(or column) cell constant in a formula while drag- 2
Formula re value in column C or D, calculations made on either in column E? 8
count cell if value present in every other cell + criteria 2
formula to display the max (or min value) for an entire column, basedon value in an individual cell 1
Add only the cells after a particular number in the previous cell in the same column 0
Continuation to equivalent for formula - to Mr. Harlan Grove (and notonly...) 1

Top