On Nov 20, 1:34 pm, nik wrote:
I need a formula that will count based on 2 criteria. For example: if one
column has words with only "hello" and "bye".. while another column says
"morning" and goodnight".

How do i create a formula that counts everyone column with a combination of
"hello" and "morning"?

Tools/Conditional sum. It will walk you through it. It creates a
pretty intense array formula.
Jay