Let's assume Col A contains (hello/bye) and Col B contains
(morning/goodnight). Try this:

=SUMPRODUCT(--(A1:A100="hello"),--(B1:B100="morning"))

HTH,
Elkar


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