Hi Guys,
I'm struggling with this one, but maybe I'm just going in mental circles. I'm in Excel 07, and I have tried several different formulas, including COUNTIFS, DCOUNTA, and regular IFS, but for some reason, it's all coming back wrong. Maybe I just entered them wrong...
Any ideas? My hair can't take much more pulling out...
Thanks!
Maybe a small Pivot Table?
try this...=COUNTIF(Sheet1!B:B,"="&A3) you need to put the = in "", else the count looks for exactly that...=A3
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
A pivot table is your best bet here, but first I'd remove formatting from the empty cells in your input sheet. Then I'd format your input area as a table. Formatting and formulas will automatically expand as needed. When inserting your pivot table, drag the dates to the rows and the total time to the values area.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks