good day all,

this thread will be the same as my introduction thread. First of all my name is Saif from Iraq, I work as a planning engineer.

Well, to get along with it, I saw a lot of excel users looking for a way to count values while to make the function works the same as sumifs.

bellow I worked on my data depending on date since I need it, I'm working in a factory so I need production quantities on a daily, monthly and yearly basis, the same for getting monthly production batches that has been produced.



column G has a month value as it's header
columns L6:BDO6 has dates values as a header
Production quantities goes from L7:BDO7

so I need to enter any month value to count produced batches for that whole month

when I enter "JAN-2021" into G6, count value for January should show up in G7.

My formula is >>

=COUNTIFS(L7:BDO7,"<>"&"",$L$6:$BDO$6,">="&$G$6,$L$6:$BDO$6,"<="&EOMONTH($G$6,0))

as we all see my 1st criteria is I told excel to count values not equal to zero, and my 2nd criteria is that I told excel to start counting only when month value is not less than January and not greater than End of January.

I hope it'd be useful for you all.

Cheers,