[Solved] Count adjacent cells that meet specific criteria
Posted: Wed Jan 16, 2019 4:51 pm
Hi,
I am trying to count cells that meet the following creteria:
"Count any cell in column A that contains “text 1” and the next cell to the right to it (in column B) contains “text 2”, where "text 1" and "text 2" are specific text data".
Searching for the solution I have found COUNTIF function, but I can't figure out how to "translate" my creteria so Calc would understand me. I believe it's something to do with VLOOKUP and IF/AND operators but I don't have any idea.
Sorry for bothering with what I believe is pretty easy task for any learned user of OpenOffice. I have never turned to Calc for anything more complex than budget spreadsheet.
I'll be gratefull for any of your advise or suggestion.
I am trying to count cells that meet the following creteria:
"Count any cell in column A that contains “text 1” and the next cell to the right to it (in column B) contains “text 2”, where "text 1" and "text 2" are specific text data".
Searching for the solution I have found COUNTIF function, but I can't figure out how to "translate" my creteria so Calc would understand me. I believe it's something to do with VLOOKUP and IF/AND operators but I don't have any idea.
Sorry for bothering with what I believe is pretty easy task for any learned user of OpenOffice. I have never turned to Calc for anything more complex than budget spreadsheet.
I'll be gratefull for any of your advise or suggestion.