HI All,
I have a spreadsheet where people log incidents, they categorise them from a dropbox list and show a date.
I want to summarise these incidents by category on a monthly basis. I would like the summary to update as the information is entered.
I'm really struggling with my formula.
I enclose my spreadsheet
Grateful for any help
Hi Betsyboo from Ireland..
You need to remove those merged cells on your data sheet so you can make the data a "good" table. Then a quick Pivot Table might give you exactly what you need. See the attached.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Perhaos try this in D8, copied down and across...
=COUNTIFS(DATA!$E:$E,D$6,DATA!$G:$G,">="&B8,DATA!$G:$G,"<="&EOMONTH($B8,0))
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
SOLVED Many thanks, suggestions offered worked a treat
Happy to help, thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks