Need Help
=SUMPRODUCT(--(A2:A200="hello"),--(B2:B200="morning"))
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"nik" wrote in message
...
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"?
|