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

Countifs with in Horizontally Criteria

Hi All,


can we count the horizontally criteria in excel countifs.


I have a Query Example-


[ Name ]

Month Week A B C D E

Jan Week 1 Input 1 5 9 4 2

Feb Week 1 Output 5 8 9 5 7

March Week 1 WiP 6 2 4 3 4
 
Hi Dhiman,


I'm not exactly sure I understand your question, so I'm guessing if this is the correct formula you are looking for?


Assuming your numbers are in columns C:G then try this and copy down


=COUNTIF(C2:G2,">0")
 
No dear actually this is not the Question the problem is I have three criteria

1-Month

2-Week

3-Name


so ( A,b,c,d,e ) I have names here and I want count A(input),B(input),C(input),D(input),E(input)same for the rest names with month and week criteria

I can do it easily with countifs but the problem is only countifs not allow horizontally criteria.


I think this is more clear or should I attached the sheet.

Regards

Nipendra
 
hi Dhiman,


why don't you use the subtotal formula with count(2) function at the top or down of your data table?


regards

sudipta
 
Back
Top