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"? |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com