ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need Help (https://www.excelbanter.com/excel-discussion-misc-queries/166807-re-need-help.html)

jlclyde

Need Help
 
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


All times are GMT +1. The time now is 12:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com