View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default COUNTIF with or + and variables

No, because there were two "AND"s and one "OR" in the OPs request.
--
David Biddulph

"Ms-Exl-Learner" wrote in message
...[i]
Try this.

=COUNTIF(I:I,"A")+COUNTIF(I:I,"B")+COUNTIF(K:K,"C" )+COUNTIF(O:O,"C")

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Dancest?r" wrote:


I'm having a hard time figuring this one out

My challenge is to count if column is "A" or "B" and column [K]
and [O] are "C"


I'm trying to count all the ones in column [J] that meet the specific
conditions.
I tried an array but it didn't seem to take.

Any hints are greatly appreciated.
.