How to search a specific column based on another cell?

[ivanbin]

So here I have a table which shows which months have 4 of a specific week day and which have 5.
I am doing this because for my work I work with people who get X amount of hours of service per month. So for example if someone gets 12 hours of service per month and gets it for 3 hours every Saturday, they will go over their 12 hours if the month has 5 Saturdays. So I need to know how often that happens (and preferably on which months if thats possible).

 

[ivanbin]

Cant seem to find edit button. Here's the image I was to attach:

https://i.imgur.com/fh6il9q.png

 

[Marcelo Branco]

Welcome to mr Excel forum

Maybe something like this

	A​	B​	C​	D​	E​	F​	G​	H​
1​	Month​	Monday​	Tuesday​	Wednesday​	Thursday​	Friday​	Saturday​	Sunday​
2​	January​	4​	5​	5​	5​	4​	4​	4​
3​	February​	4​	4​	4​	4​	4​	4​	4​
4​	March​	4​	4​	4​	4​	5​	5​	5​
5​	April​	5​	5​	4​	4​	4​	4​	4​
6​	May​	4​	4​	5​	5​	5​	4​	4​
7​	June​	4​	4​	4​	4​	4​	5​	5​
8​	July​	5​	5​	5​	4​	4​	4​	4​
9​	August​	4​	4​	4​	5​	5​	5​	4​
10​	September​	5​	4​	4​	4​	4​	4​	5​
11​	October​	4​	5​	5​	5​	4​	4​	4​
12​	November​	4​	4​	4​	4​	5​	5​	4​
13​	December​	5​	5​	4​	4​	4​	4​	5​
14​
15​	Count > 4​	4​	5​	4​	4​	4​	4​	4​
16​		List​	List​	List​	List​	List​	List​	List​
17​		April​	January​	January​	January​	March​	March​	March​
18​		July​	April​	May​	May​	May​	June​	June​
19​		September​	July​	July​	August​	August​	August​	September​
20​		December​	October​	October​	October​	November​	November​	December​
21​			December​
22​

<tbody>
</tbody>

Formula in B15 copied across
=COUNTIF(B2:B13,">4")

Array formula in B17 copied across and down (gray area)
=IF(ROWS(B$17:B17)>B$15,"",INDEX($A$2:$A$13,SMALL(IF(B$2:B$13>4,ROW($A$2:$A$13)-ROW($A$2)+1),ROWS(B$17:B17))))
confirmed with Ctrl+Shift+Enter, not just Enter

Hope this helps

M.