• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

OR in COUNTIFS

V

vaidmohammed

Member
How to use OR function in COUNTIFS.

I am trying to use OR function in criteria but it is not working.

=COUNTIFS(A2:A10,(OR("PS","LA")),B2:B10,C2)

This formula I am trying to use to extract information about how many observations have been identified by my resources PS and LA.

Please help.
 
Hi Vaid ,

Try this array formula , entered using CTRL SHIFT ENTER :

=SUM(COUNTIFS(A2:A10,{"PS","LA"},B2:B10,C2))

Narayan
 
vaidmohammed said:
How to use OR function in COUNTIFS.

I am trying to use OR function in criteria but it is not working.

=COUNTIFS(A2:A10,(OR("PS","LA")),B2:B10,C2)

This formula I am trying to use to extract information about how many observations have been identified by my resources PS and LA.

Please help.
Click to expand...
Hi,

And another.

=SUMPRODUCT((ISNUMBER(MATCH(A2:A10,{"PS","LA"},0))*(B2:B10=C2)))
 
@Somendra Misra .. have you tried the formula...?
If not then try is first..
Because in sumproduct formula.. everything goes as array...
and there is a meaning that I have used.. "--"

Regards,
Vikas gautam
 
Hi Vikas_Gautam

may be Somendra doesn't tried your formula..
why dont you upload a sample file with your provided formula.. and correct answer.. so that we also learn some new trick..


Another way.. using Ctrl+Shift+Enter
=SUM((B2:B10=C2)*(A2:A10={"PS","LA"}))
 
You must log in or register to reply here.
Back
Top