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,
Bookmarks