Need Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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"?
 
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"?
Click to expand...

Tools/Conditional sum. It will walk you through it. It creates a
pretty intense array formula.
Jay
 
=SUMPRODUCT(--(A2:A200="hello"),--(B2:B200="morning"))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
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
 
Back
Top