I have a spreadsheet that contains data for schedule activities showing start and finish dates that are grouped by the weekly update date. See attached spreadsheet. I am trying to create a countif formula that will reference the column based on "start_date" header as well as the merged update date header.
Can you provide an example of the result you are looking for, with specifics about how it is arrived at?
Please add reputation by clicking on the * if I have helped.
Please mark the thread SOLVED if your issue has been resolved.
Thanks, Glenn.
...and count what?I am trying to create a countif formula that will reference the column based on "start_date" header as well as the merged update date header.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I am looking to count the number of activities that were planned to start within the week. (ex. in the week of 5/5/15 I need to count the number of activities that were planned to start that week from 5/5/15 - 5/11/15.) Then I need to count the number of activities that actually started based on the following weeks information and then calculate a percentage from that.Originally Posted by gak67
See revised file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks