I am trying to count the number of units based on the given criteria.
Eg : Criteria 1 L9 and Criteria 2 K10 . Enclosed sample sheet. Thanks in advance
I am trying to count the number of units based on the given criteria.
Eg : Criteria 1 L9 and Criteria 2 K10 . Enclosed sample sheet. Thanks in advance
Suggest you explain your logic as it is not obvious from your presentation. What are you counting and how?
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
I am trying to count the number of rows having value under each column header (10-14) for >30 in column H
Hi All,
in L10 to be copied down
=SUMPRODUCT((B$8:F$523>30)*(B$7:F$7=K10))
Hope that helps
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Seems something off. I got my L10 answer is 7 but the correct answer should be 37.
How about
=COUNTIFS(INDEX($B$8:$F$523,,MATCH(K10,$B$7:$F$7,0)),"<>",$G$8:$G$523,">=31")
This is working fine for me. Thanks for the assistance.
You're welcome & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks