# 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

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.
Your formula would then be:
=COUNTIFS(T:T,"On time",Z:Z,WEEKNUM(TODAY()))

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...

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

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

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

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")?

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

@crossfirepower

Maybe you can try the formula and you will know.

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.

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

Then post an exampel of your Excel file without confidentional information

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

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

I advice a pivot table.

see the attached file.

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")

##### Users Browsing this Thread

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