We are focusing on Row 16. The formula: =COUNTIFS('Capacity SO'!$C:$C,">=1/24/2011",'Capacity SO'!$C:$C,"<=1/30/2011")
Just start with Column E first. It is possible to make "1/24/2011" E9, so that if I change the date in E9 it will also change the formula to search for values >= to E9?
Attached is the spreadsheet in question.
Last edited by SeanKosmann; 01-27-2011 at 11:06 AM.
Try:
=COUNTIFS('Capacity SO'!$C:$C,">="&E9,'Capacity SO'!$C:$C,"<="&E10)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
THANK YOU!! I knew I was missing something!! Stupid "&" sign!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks