LinkBack URL
About LinkBacks
Column B contains dates formatted mm/dd/yyyy.
=MONTH(B5) returns the correct value.
Why doesn't =COUNTIFS(B17:B328,"MONTH=11") work?
The goal is to count each cell that contains a particular cell.
Thanks!
Column B contains dates formatted mm/dd/yyyy.
=MONTH(B5) returns the correct value.
Why doesn't =COUNTIFS(B17:B328,"MONTH=11") work?
The goal is to count each cell that contains a particular cell.
Thanks!
=SUMPRODUCT((MONTH(b17:b328)=MONTH(b5))*1)
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Countif function works.. to count.. how many cell instance have the word found..
Capture.JPG
iNSTEAD TRY..
Formula:
Please Login or Register to view this content.
Regards!
=DEC2HEX(3563)
If you like someone's answer, click the star to give them a reputation point for that answer...
Didn't work.
#VALUE!
=SUMPRODUCT(--(MONTH(B17:B328)=11))
Didn't work.
#VALUE!
There must be some data.. which are TEXT..
please upload a sample file..
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
This works: =SUMPRODUCT((MONTH(B17:B328)=H56)*1)
Just have to have the month value in the cell it equals.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks