Hello, I am new to this forum. Hoping I can get some help and be of help to others. Soooo now to my problem. I have a list of 250 incidents with a date. I am trying to determine how many of the incidents occur each month based off the location. My location is a drop down with 5 different categories.
Currently I am using =SUMPRODUCT((MONTH(Data!$A$2:$A$5000)=1)*(YEAR(Data!$A$2:$A$5000)>1999)) for the entire data.
I tried =IF(Table25[[#All],[Location]]="Education",SUMPRODUCT((MONTH(Data!$A$2:$A$5000)=4)*(YEAR(Data!$A$2:$A$5000)>1999)),"nope") but that only looks for it in one cell.
Thanks for the help, again I am new so if I need to try to explain it better please let me know,
Scott
Bookmarks