• 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.

Count with multiple range of values

ARJUNDSOUZA

New Member
Dear Excel Gurus,

Need your help, I would like to know how many entries in column L have a values as listed in Cells B1, C1,D1,E1.... (these are set as text, would actually want it also as numbers). I have done a simple countif in column P but really looking for the table format A1:I2

Highly appreciate your assistance.

Kind regards
Arjun
 

Attachments

p45cal

Well-Known Member
Another way: if you're using Office365 then in cell B2:
=TRANSPOSE(FREQUENCY(L2:L861,{0,3,7,14,29,45,59}))
If you're using an earlier version select cells B2:I2 and commit the above formula to the all those cells at once using Ctrl+Shift+Enter rather than the usual plain Enter.
 
Top