# Countifs to be working the same as sumifs function

1. ## Countifs to be working the same as sumifs function

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,

2. Hello saif Khalid,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

3. ## Re: Countifs to be working the same as sumifs function

Originally Posted by arlu1201
Hello saif Khalid,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
Thanks arlu, it's a pleasure to be part of this community.

4. ## Re: Countifs to be working the same as sumifs function

Just looking at post #1 it appears the the value in G6, JAN-2021, is text.
So my first suggestion is to make sure that the value in G6 is a date i.e. 1/1/2021
My second suggestion, in case the first doesn't help, is to utilize the instructions in the banner at the top of the page to upload a sample of the Excel file described in post #1.
Let us know if you have any questions.

5. ## Re: Countifs to be working the same as sumifs function

First of all thanks for the explanation, secondly my post wasn't a question I was trying to give help to anyone that needed a formula that counts values of month when month is written, again I really appreciate the your help.

Cheers.

6. ## Re: Countifs to be working the same as sumifs function

You should have posted in the Tips & Tutorials section - I'll move this there now.

7. ## Re: Countifs to be working the same as sumifs function

Originally Posted by AliGW
You should have posted in the Tips & Tutorials section - I'll move this there now.
Well, I posted this thread as an introduction of myself since it was my first post here, anyways all efforts are appreciated Ali.

Cheers.

8. ## Re: Countifs to be working the same as sumifs function

My point is, you posted in the wrong place. NOBODY will look for hints and tips in the introduction section, so sharing the tip would be fruitless. I can move it back to where nobody will ever see it if you want.

10. ## Re: Countifs to be working the same as sumifs function

In advance of what? You want me to move it back where nobody will ever see it? Are you sure???

11. ## Re: Countifs to be working the same as sumifs function

Thank you in advance for moving it into tips and tutorials section.

12. ## Re: Countifs to be working the same as sumifs function

Have a good day!

13. ## Re: Countifs to be working the same as sumifs function

:D, well Thanks anyways.

Cheers.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1