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
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
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()))
Taming the Excel dragon... www.TheExcelphile.com
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...
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
Hope this will be a simple way to solve this. pls find attachment.
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")?
@crossfirepower
Maybe you can try the formula and you will know.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I did and it didn't which is the reason why I'm asking for further instruction.
Then post an exampel of your Excel file without confidentional information
"Oeldere" if it were tha easy I would. Here is a sample of what I'm referring too(attached).Monster Mash (Sample).xlsx
I advice a pivot table.
see the attached file.
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")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks