Hello,
I have been using this formula
=COUNTIF(Master!I:I,'Source Lists'!A1) It is counting trends for the year, in a summary tab. (this works)
(Master is a tab with all the daily information for incidents, The Source list is a seprate tab where I put my pull down menu information, and this is going in a thrid tab called trends. )
The "master" tab has a date column 01/11/12 format I would like to set up the summry tab by month is there a way to add that to this formula?
Currently the trend tab/sheet looks like this
......................Total
MUI - Verbal ......5
MUI - Physical.....0
MUI - ***...........0
I want to track trends monthly and quarterly
...................... Jan.... Feb ...March .... Total
MUI - Verbal........2.....3........0
MUI - Physical .....0.....0........0
MUI - *** ...........0.....0.......0
I hope I have given enough inoformation, Thank you, Excel 2010
Bookmarks