# count if date is this week

1. ## count if date is this week

I need to write a formula which will count cells column T that say 'on time' but only if the date in column m is this week. I have got as far as =SUMPRODUCT !
The date bit is where I'm struggling. Thank you x  Register To Reply

2. ## Re: count if date is this week

Try Countifs.
Add a column where you use the WEEKNUM() function to calculate the week number of the date in column M. Lets say you've used the column Z for this.
=COUNTIFS(T:T,"On time",Z:Z,WEEKNUM(TODAY()))  Register To Reply

3. ## Re: count if date is this week

I think is the right place within this forum to ask my question... I need a formula (I think COUNTIFS) that will count numbers that are equal to "1" but only if a specific word is listed in another column. For instance... If "Donkey" is listed in column "A" then I need the formula to count the number listed a corresponding column (could be "B") but only if it is equal or less than "1". I appreciate any help...  Register To Reply

4. ## Re: count if date is this week

Crossfirepower, use the following formula:

=COUNTIFS(A:A,"Donkey",B:B,"<=1")

Don't forget to click on the little star on the left of this post if you feel I helped   Register To Reply

5. ## Re: count if date is this week

Hope this will be a simple way to solve this. pls find attachment.  Register To Reply

6. ## Re: count if date is this week

Yes and no (this helped). I forgot to tell you that the information comes from the first worksheet "Billet Roster" and will fill a specific cell on the second worksheet.

Would it then look like =COUNTIFS(!Monster Mash!A:A,"Donkey",!Monster Mash!B:B,"=<1")?  Register To Reply

7. ## Re: count if date is this week

@crossfirepower

Maybe you can try the formula and you will know.  Register To Reply

8. ## Re: count if date is this week

I did and it didn't which is the reason why I'm asking for further instruction.  Register To Reply

9. ## Re: count if date is this week

Then post an exampel of your Excel file without confidentional information  Register To Reply

10. ## Re: count if date is this week

"Oeldere" if it were tha easy I would. Here is a sample of what I'm referring too(attached).Monster Mash (Sample).xlsx  Register To Reply

11. ## Re: count if date is this week

see the attached file.  Register To Reply

12. ## Re: count if date is this week

If you do want to use a formula instead of a pivot table, use the following formula:

=COUNTIFS('Monster Mash'!A:A,"Donkey",'Monster Mash'!D:D,"<=1")  Register To Reply

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