Multiple condition COUNTIF

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I'm having trouble coming up with a formula to count the
number of occurances of a certain variable in one column
based on if a condition is met in another column. More
clearly, I have a column with different customers and I'm
trying to sum up the number of times they have a closed
order in the order closed column. The column will yield a
blank if the order is not closed and should not be
included in the count.

Help would be greatly appreciated!

Thanks!
 
If you search for "multiple condition countif" you'll find the answer, but
just to add to it..

=SUMPRODUCT((A1:A100="Certain variable")*(B1:B100="whatever signals that
order is closed"))
 
The search only gives a single condition countif.
I'll try your other suggestion. Thanks very much!
-----Original Message-----
If you search for "multiple condition countif" you'll find the answer, but
just to add to it..

=SUMPRODUCT((A1:A100="Certain variable")*
Click to expand...
(B1:B100="whatever signals that
 
=SUMPRODUCT((A1:A100=cust_name)*(B1:B100="closed"))

or something similar

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Sorry, I wasn't clear. I meant search the newsgroup for this term, as it's
common people want to do multiple condition countifs, and they are usually
referred to array SUM or the more common SUMPRODUCT.
 
Back
Top